Grouped by Query Access 2000

  • Thread starter Thread starter George Wilson
  • Start date Start date
G

George Wilson

I am creating a query grouped by group (the field name),
then by date range (what week it falls under) and then by
the progams booked. The query returns the correct groups
and date groups but I need to show all programs in these
groups. I tried first and last but it does not show them
all. Is there a Total expression I can create to show all
the programs which may occur under a certain date range?
In other words under the listed date range February 9-13
show multiple program listings. Right now the items are
grouping correctly by the date range but I need to show
all of the items listed in that group in one field on the
query. Any suggestions?
TIA
George
 
Whenever you do a GROUP BY, it can only feed the items that exist.

What you can do, is create a query based on the Group By query that has an
outer join to the Programs table. This will allow you to show ALL programs.
Those programs w/o dates will have null values for those programs.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top