Connecting Tech Pros Worldwide Help | Site Map

grouping in forms access 2003

  #1  
Old November 9th, 2007, 11:25 PM
nina
Guest
 
Posts: n/a
is there a way to group records in forms in 2003 version
ie. i have number of records with date and would like to see it in this way
on a form

sep 2007
rec1
rec2
rec4
..
..
..

oct 2007
rec1
rec2
....

i know haw to do it in a report, but is there a way to do it in form?

tnx


  #2  
Old November 10th, 2007, 04:55 AM
Allen Browne
Guest
 
Posts: n/a

re: grouping in forms access 2003


No: a continuous form cannot display data like that.

One workaround might be to place a combo on the main form to choose the
month and year, and then filter the subform to show only the matching
records.

I guess you could use 3 subforms, where the middle one shows the selected
month, the upper one the previous month, and the last one the next month.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"nina" <nina@nina.comwrote in message
news:fh2pmi$ioc$1@ss408.t-com.hr...
Quote:
is there a way to group records in forms in 2003 version
ie. i have number of records with date and would like to see it in this
way on a form
>
sep 2007
rec1
rec2
rec4
.
.
.
>
oct 2007
rec1
rec2
...
>
i know haw to do it in a report, but is there a way to do it in form?
>
tnx
  #3  
Old November 10th, 2007, 07:35 AM
JHB
Guest
 
Posts: n/a

re: grouping in forms access 2003


Only if you use a treeview

"nina" <nina@nina.comskrev i en meddelelse
news:fh2pmi$ioc$1@ss408.t-com.hr...
Quote:
is there a way to group records in forms in 2003 version
ie. i have number of records with date and would like to see it in this
way
Quote:
on a form
>
sep 2007
rec1
rec2
rec4
.
.
.
>
oct 2007
rec1
rec2
...
>
i know haw to do it in a report, but is there a way to do it in form?
>
tnx
>
>

Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2003 v/s Access 2007 prakashwadhwani@gmail.com answers 9 June 27th, 2008 08:24 PM
Access 2003 Crash JK Peck answers 14 November 13th, 2005 04:46 AM
Acces & NT - Good Practice Paul Wagstaff answers 2 November 12th, 2005 02:14 PM