Grouping on Forms

  • Thread starter Thread starter Jack Thomas
  • Start date Start date
J

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
 
Jack said:
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?
Click to expand...


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
 
Back
Top