Dear Access 97 Experts,
I have created a Purchase Invoice Matched Document Header
within Access 97, that the Accounts department in my organisation can print out and staple to the front of each Supplier's Invoice ready for payment.
However, I have a problem with the Report, which I hope you can advise me on.
Problem
I need my Report to display data just as it does in a standard invoice,
ie:
Item No. 1 Description Line Value
Item No. 2 Description Line Value
Item No. 3 Description Line Value
Item No. 4 Description Line Value
But instead, it is displaying:
Item No. 1 Description Line Value
Item No. 1 Description Line Value
Item No. 1 Description Line Value
Item No. 1 Description Line Value
Instead of the data for all 4 items being displayed in one report, it displays 4 separate reports,
ie:
Report 1 shows Item 1, Description and Line Value
Report 2 shows Item 2, Description and Line Value
Report 3 shows Item 3, Description and Line Value
Report 4 shows Item 4, Description and Line Value
When the query is run, it shows the following main
Columns along with many others:
Item No.
Item Description
Line Value
(There are no duplicate Values in the query when it is run).
If anyone out there can advise me on how I can get the Report to show all Item Nos with their related Description and Line Values, in the same Report it would be much appreciated.
Thanks
Antony
I have created a Purchase Invoice Matched Document Header
within Access 97, that the Accounts department in my organisation can print out and staple to the front of each Supplier's Invoice ready for payment.
However, I have a problem with the Report, which I hope you can advise me on.
Problem
I need my Report to display data just as it does in a standard invoice,
ie:
Item No. 1 Description Line Value
Item No. 2 Description Line Value
Item No. 3 Description Line Value
Item No. 4 Description Line Value
But instead, it is displaying:
Item No. 1 Description Line Value
Item No. 1 Description Line Value
Item No. 1 Description Line Value
Item No. 1 Description Line Value
Instead of the data for all 4 items being displayed in one report, it displays 4 separate reports,
ie:
Report 1 shows Item 1, Description and Line Value
Report 2 shows Item 2, Description and Line Value
Report 3 shows Item 3, Description and Line Value
Report 4 shows Item 4, Description and Line Value
When the query is run, it shows the following main
Columns along with many others:
Item No.
Item Description
Line Value
(There are no duplicate Values in the query when it is run).
If anyone out there can advise me on how I can get the Report to show all Item Nos with their related Description and Line Values, in the same Report it would be much appreciated.
Thanks
Antony