JaredNJames
Registered User.
- Local time
- Today, 07:09
- Joined
- Jul 7, 2007
- Messages
- 87
Hi, sorry to bother you all again . . .
i have a form which you enter invoice details into.
it has a subform which is in datasheet view which you can select multiple items in. (you choose an item, it gives you the price, you enter a quantity.).
So nice and simple.
I have a save command on the ok button so that the form saves once finished with.
my problem is fairly simple:
when accept is pressed, i want a report to print showing the information in the style of an invoice. The main fields like invoice id, car reg and date along the top, with a list of invoice items down the page in tabular form.
my problem is, when i have tried to query the table to bring up the data, the query returns multiple fields (as in invoice id, car reg and so on are repeated).
I also dont know how to bring up the subform data below it.
Any help much appreciated.
jjames
i have a form which you enter invoice details into.
it has a subform which is in datasheet view which you can select multiple items in. (you choose an item, it gives you the price, you enter a quantity.).
So nice and simple.
I have a save command on the ok button so that the form saves once finished with.
my problem is fairly simple:
when accept is pressed, i want a report to print showing the information in the style of an invoice. The main fields like invoice id, car reg and date along the top, with a list of invoice items down the page in tabular form.
my problem is, when i have tried to query the table to bring up the data, the query returns multiple fields (as in invoice id, car reg and so on are repeated).
I also dont know how to bring up the subform data below it.
Any help much appreciated.
jjames
