Lance,
I was curious how to setup a query that would allow me to check on some 
sub-fields and have them as fields in a report without having to use an 
excessive amount of banding.
I have a source field that usese a lookup table.  The source refers to where 
an applicant heard about our company.
For each source there is another field with the same heading, newspaper, 
radio, tv, etc.  Each one of these fields utilizes a lookup table with a 
particuliar source, News & Leader, KGBX, etc...
I would like to have a report that has a band for the source and then for 
each source band be able to list each sub-reference to the source on a line 
with the given total for the sub-reference/source.
The first band in the report is a date field.
Where I run into the problem is that there can be multiple sub-sources.  IE 
for newspaper there could be two or three sub-sources for the same day.
While I can get close using a query and several bands I must be overlooking 
something in the report setup.
Any suggestions?
Frank
--- GEcho 1.10+
---------------