I was wondering if there was a way to pull up specific records from a grouping, place them where you want on the report and if there's no record to match your criteria then come back with 0.

I have to create a report that needs to look exactly like what the company is using now, in the specific order they have it. The table I recieve in text format doesn't include records from the system that have a 0 count. Ideally I was hoping there was a code to put in a textbox that would pull a record with criteria and if not, leave a zero.

I have tried, but keep getting repeats of everyone in the detail section

Thanx

Hi

If my understanding is right then you have a table that has ALL the records that you meed to report on but not specific detail - which comes down in a text format. The text format then becomes a table?

If so then set up a relationship between the two tables on the two tables - I assume that the common field is a unique identifier.

Then, with the relationship in place, set up a query with the first field being the unique identifier but taking the data from the table which came in text format. Anthing with novalue will then have a null value in the query but will still show on the report.

I hope I haven't misunderstood what you said but it seems to make sense to me!

Andy

Did you get my post describing how to use an append query to put zeroes into "absent fields? " Didn't that work?