I have a Word form that uses merge fields to bring data from multiple tables in Access into the form for printing. The form is based on a query joining the multiple tables.
For example Customer ID in the table equates to Customer ID on the Word form, etc.
This is done with a straightforward query, not using VB code.
Because of recent revisions to the data entry process, I now need to pull out multiple entries from some tables.
For example, Customer 25478 may have more than one instances of a price for a certain item. The first item might be 5.00. But if the customer buys 2 or more pieces, the price is $4.50 each.
I want all the instances to show on the Word form in a grid.
For example Customer ID in the table equates to Customer ID on the Word form, etc.
This is done with a straightforward query, not using VB code.
Because of recent revisions to the data entry process, I now need to pull out multiple entries from some tables.
For example, Customer 25478 may have more than one instances of a price for a certain item. The first item might be 5.00. But if the customer buys 2 or more pieces, the price is $4.50 each.
I want all the instances to show on the Word form in a grid.
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar