cannot get query results

[steve111]

hi

I have a query that I am really struggling with. been working on it for days

I am trying to create a invoice for the 8 items in the orders subform on the "invoice form " but I need to be able to have free input to the "quanity 1 "field as I might not invoice the full amount
at present I am coping the data to the "invoicedetails subform" which is duplicating the data and I don't to do . but I cannot find another way


the query is called " invoice report query"

when the open invoice button is pressed you are prompted for a number which is "1!

any help would be appreciated
steve
I have attached a database

"

 

[apr pillai]

Copy pasting details from Order-Details file is the easiest method you found to reduce the work involved. Are you trying to build an inventory database? You have a perfect example database (Northwind.accdb) to study the subject from in your machine.

In real situations you may not be able to supply all the items/quantity ordered by your Customer, as in the Order-detail file, or for the price given in the order file. You will be pulling items available in your stock from your Product file, one-by-one and will be adding into the Invoice Detail file, with the current stock price.

Study the subject little more detail; you don't have to struggle too much to build your database.

 

[steve111]

hi

I an trying to get the order details into the invoice report except for the order qty as his may vary but I need to be able to change that in the invoice details form

If I put all the information in the invoice details form it works Ok But this is not the correct way

steve

 

[smig]

I'm trying to understand your tables structure.
Why do you have both orders and invoices? Aren't they same?

 

[Rabbie]

Not necessarily. You might be including several orders on one invoice. I do this where customers are invoiced on a monthly basis but may order at any time and are given credit for a certain period

 

[steve111]

hi,

yes.
but I need a invoice header, for invoice dates, shipping cost etc and special invoice information that is not on the order details. and don't want them to be.
i also need a invoice qty field for all the items in the order incase I part invoice the some of he order. but i could not get the query to work .

i need if possible all the information in the invoice header , these fields from the order details

productno, price, cdescription, pdescription,

and free input in the invoice details for the qty as these will/could be different to the order details

the customer details, shipping etc works ok

hope this helps
steve