Hey Richard and the Guys, I am trying to setup the our "Invoice Report" with the Service and Product Item in the Report displayed together. I am wondering if it possible to do?
James Hopkins 3 months ago
Kevin Robertson 3 months ago
I would probably use a couple of Subreports for this (easier option).
You could build a query that has all the required fields from the necessary tables and set up
Grouping levels both services and products.
Scott Axton 3 months ago
Does the Combine Reports help you?
Just don't put in the page break.
Hey Guys, is they an Seminar or Course on Reports?
Scott Axton 3 months ago
No - not specifically on reports. Reporting is covered through out the courses and TechHelp as needed or to show different techniques.
If you take a look at the Microsoft Access Outlines and search report (Ctrl-F) you will get 328 matches.
Do you have something in mind?
James Hopkins 3 months ago
Richard, I have "Invoice Details Query" that have that we calculate all the"Sale Taxes, Subtotal, Discount, and Complete Invoice Total ". Also, I have an "Invoice Info Query" has everything: the InvoiceT and the InvoiceDetailT. Trying to figure out the way to display the "Products and the Services" in the Same Reports?
James Hopkins 2 months ago
Hey Crew, I think I have it... I just got it to display the right Customer for the "Invoice Detail Form".
Scott Axton 2 months ago
That's good news!
Once you have it working you might post a "here was my issue and this is how I did it" just in case others might find it of use.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
