Hi Nico
Thanks for your reply
If I wanted to add more fields to the quert for example a No of Vouchers, Number of books, branch address and the Product related fields how would I do this to work in this query?
Sorry to be a pain mate
Cheers
Simon.
Simon Bernard
Last Activity: Oct 26 '10, 10:22 AM
Joined: Oct 22 '10
Location:
-
Hi mate
Thanks for the sending the code...it worked :D
How would I get the Branch Address fields to appear in the same line?
E.g.
Order No, Branch, Address1, Address2, P1, P2, P3
(P1,2,3 - the products associated to the order no)
Thanks again mate...sorry if this question appears twice, I wasnt sure if my last post was sent)
Cheers
Si...Leave a comment:
-
Hi Nico,
The code you wrote worked thanks mate.
Another thing, how would I get the Branch Address fields to appear on the same line as the order/branch?
E.g. Order No, Branch, Address 1, Address 2, P1, P2, P3
(P1,2,3) = Product Value 1 etc)
Thanks again mate
SimonLeave a comment:
-
Database Attached
Hi Guys
Please see attached the database that I am working on
Any help would be hugely appriciated.
Some useful things to note
- 1 Branch can order many Products
- I want all the items ordered by the branch on the day that they placed the order to be on 1 document (Delivery Note). This in term means the Order No will appear once on the combined Delivery
Leave a comment:
- 1 Branch can order many Products
No activity results to display
Leave a comment: