Very basic report problem

[ndendrinos]

Hello to all,
I have a simple Access database linked to an Excel sheet.
The table in Access when populated shows the following headers:
Invoice No / Date / Company / Cheque / Visa / Master Card
All links to the Excel sheet work.

I've set up a report with the wizard and chose :
Inv No/Company/Date/Cheque and for sorting I chose Company / Invoice / Date

Two problems and a "how to" question.

Problems:
a) Why is it that the result for a single line report is on page 66 and not on page 1?

b) Why is it that an invoicxe paid by Visa shows on the report of invoices paid by cheque ? ( the total for the transactions other than by cheque have an empty field where the amount should be... why do they show then at all?)

Question : how can I total several invoices by company ?
for example
Inv....Company....Date,,,,Cheque
2......CompanyA...10-01...$10.00
3......CompanyA...10-01...$20.00
4......CompanyA...10-01...$30.00
4......CompanyA...10-01...$40.00
TOTAL............................$100.00

Thank you

 

[mdmilner]

The answer must lie in the criteria you're using to show the report.
Criteria are like saying "only use this record (row) if the value right here (in this field) is meets some test (such as equal to a value or word)"

Take a look at the recordsources for your reports. If they're based on a Query, look at the query in Design mode and see what the criteria is. I'll bet you find something you forgot about.

Mike

 

[ndendrinos]

Hello Mike,
Just solved the first two parts ... so now the reports are fine.
Still don't know how to total but I'm working on it.
Regards
Nick

 

[Andrew Fergus]

Hi,

to get subtotals on your report, go to the report design view, Click View -> Sorting and Grouping -> you can create a new sorting and grouping level (or edit the one that is there for the company), group footer should be "yes", close and in the new section of the report (company group footer) you can enter in a new field that sums the values you want.

Sorry I haven't explained it very well but if you can get to the sorting and grouping screen then it is pretty easy to follow from there.

HTH, Andrew.

 

[ndendrinos]

Hello Andrew.
Had all but forgotten about this post until this evening that is.
Wish to thank you for your help and will follow your advise.
Regards,
Nick

 

[ndendrinos]

All done Andrew.
Thanks a lot