Grouping on Forms

[Jack Thomas]

Is there any way to group data on a continuous form in the
same manner that is done on reports? If so can someone
point me in the right direction for information or give
and example to help?

Loads of Thanks

 

[Marshall Barton]

Is there any way to group data on a continuous form in the
same manner that is done on reports? If so can someone
point me in the right direction for information or give
and example to help?

No, forms do not have a grouping feature so there is no such
thing as a group header/footer section.

OTOH, you might be able to come up with some kind of tricky
query that calculates something you may be able to make look
like a group header, but it would not be an updatable data
set. E.g.

SELECT Region, Customer
FROM table
UNION ALL
SELECT Region , "---" & Region & "---"
FROM table
GROUP BY Region
ORDER BY 1,2