query for an invoice.

[lakersfan34]

i need to create an invoice, but i need to create a query to make the date for the invoice. here is my datebase, how exactly do you make the query in order to generate the invoice.



http://www.4shared.com/file/gj4DSaJ8/Database11.html

[June7]

Use the query designer. This is very basic Access functionality and Access Help has guidelines on using the designer. Open the designer, pick tables. Since you have relationships established the designer will automatically set the join links. Try it, it's easy!

[lakersfan34]

its not the actual invoice im having problems with its the query im trying to make to run for the invoice. for the invoice to show this type of data

http://www.4shared.com/file/RsH2xfzh...Henderson.html

how should i set up the query?

[June7]

What is the exact problem? Did you open query designer and pick tables that have the fields you need for report? Then build report. Use report Grouping & Sorting functionality to arrange the data.

If you want to output invoice for only one company or invoice or period, apply filter criteria to the query.

[lakersfan34]

nevermind, i misread your last comment, i understand now, once i prepare the query for the invoice how do i make it where the query prompts me to enter the name of my client the invoice is for?

[June7]

You can use input parameter prompt in the query but I don't like them, can't validate user input. I have users input criteria in controls (textbox, combobox, listbox) on a form and refer to the controls as input parameters. Again, look for guidelines in Access Help on input parameters, search on topic: query input parameters.

My preference for opening a filtered report (or form) is to use the WHERE argument of DoCmd.OpenReport (or OpenForm). I use only VBA but I think a macro can also do this. Again, search Access Help on the topic.

[lakersfan34]

im trying to build the invoice but for each entry it reputs the name and everything again, how to i make the invoice where it has the name adress and what i need once at the top then all the orders instead of each order having the name and adress above it. id like it to look like this

http://www.4shared.com/file/RsH2xfzh...Henderson.html

[June7]

Use Grouping & Sorting. Review Access Help on that topic and explore the attached example report of your data and see if it is like what you need.