Group By In Forms?

[Maritza]

Is there a command, or coding that would allow you to group records by categories in a form. Similar to what we can do in the reports?

Thanks

 

[Robert Dunstan]

Hi there

There is no sorting or grouping that I know of in the design of a form like you can in a report. One suggestion you may want to consider is using a crosstab query and then base your form on that. Unfortunately I don't use crosstab queries very often so the only thing I can advise is to try it and see if it gives you the desired results. May be someone else might have a better idea.

HTH
Rob