grouping in forms access 2003
am 10.11.2007 00:38:24 von nina
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
Re: grouping in forms access 2003
am 10.11.2007 05:45:31 von Allen Browne
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" wrote in message
news:fh2pmi$ioc$1@ss408.t-com.hr...
> 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
Re: grouping in forms access 2003
am 10.11.2007 08:29:30 von JHB
Only if you use a treeview
"nina" skrev i en meddelelse
news:fh2pmi$ioc$1@ss408.t-com.hr...
> 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
>
>