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
"
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
"