Need some help with Invoice in Report.

[Temujin]

Hi,

I am trying to make an invoice report on Access and I've come across a problem. When I have two of the same invoice numbers that includes the same customer but different parts, it generates two invoices when viewing it in report. Is there any way to have one invoice and the parts simply underneath each other? I am probably not explaining it right but here is a screenshot.

Thanks in advance.

[hertfordkc]

Another question: is your report based on a query which has things grouped and sorted consistent with your vision of the report?

[Temujin]

The report is based on a query but I don't believe I grouped anything, I might have not understand that question clearly. My knowledge in Access is still pretty low.

Would it help if I provided a download for the db file?

[hertfordkc]

The report is based on a query but I don't believe I grouped anything, I might have not understand that question clearly. My knowledge in Access is still pretty low.

Would it help if I provided a download for the db file?

The 'Report' design in Access provides for grouping, so at the very least you should be using that in the report that you are trying to create. You can also create grouping in the query, which may or may not be helpful or necessary for your report.
Please google these for explanation and examples.

[Temujin]

I will look it up thanks. I uploaded my DB on mediafire, here is the link;

http://www.mediafire.com/?x1e7q8vldhv4eqb

[dblife]

If you open the report in design view, you will have a method for sorting and grouping. You need to have this set so you only see the order number and customer grouped.

[Temujin]

Thanks for the advice and I tried grouping customer number and the invoice number so only one set of invoice would show for one customer but with no luck

[dblife]

You could probably just use the invoice number rather than the customer number too? One invoice number will only ever have one customer - is that safe to say?

[Temujin]

You could probably just use the invoice number rather than the customer number too? One invoice number will only ever have one customer - is that safe to say?

Yes, thats right. I tried grouping in the report's Design View for invoice number alone but to no avail. Unless I'm doing it wrong. I right-clicked "Sorting and Grouping" in Design view, then did sort by Invoice Number and after going into Report view, it still stays the same. Two seperate invoices with identical invoice numbers and customer but seperate details on the parts they purchased.