beginner's question

[XKIMBAL]

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

 

[AndyS48UK]

Zero records

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

 

[cogent1]

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