Printing a report problem!

[George II]

I have a very basic Access 2000 database for keeping track of my sales in a publication.

I am printing a report from a query. In the query, a company is listed twice... the two records for this company are different as in one field, which represents the page number the company is on, is different (1 & 108).... However, the report will not show the company twice. Yet, it leaves a space for it and the total for sales at the bottom of the report is correct (includes the invisible record)..... what do I need to do to have this second record show up?

Thanks,

George II

 

[doss]

I think I understand what you are saying. Sometimes it's hard without actaully seeing the report....

Do you have a grouping header by company name? If you do, this could be why it's only showing the first record but adding everything up at the end......

If this is what's happened, You might want to make a copy of your report put the company name in the detail section just to if it shows up....

 

[George II]

I think I understand what you are saying. Sometimes it's hard without actaully seeing the report....

Do you have a grouping header by company name? If you do, this could be why it's only showing the first record but adding everything up at the end......

If this is what's happened, You might want to make a copy of your report put the company name in the detail section just to if it shows up....