Tech Support Guy banner
Status
Not open for further replies.
1 - 1 of 1 Posts

·
Registered
Joined
·
19,932 Posts
ChipT, welcome to the Forum.
What you have described is what you do.
Create a Query for table 1 with the Customers and Bill codes.
Add table 2.
Add a new column, in the heading put the following
resultBC1: tablename1.[BC1] * tablename2.[BC1]
Add a new column, in the heading put the following
resultBC2: tablename1.[BC2] * tablename2.[BC2]

where tablename is the actual names of the 2 tables.

This Table structure is OK for data entry but far from ideal design wise. If you have to add a BC3 later you have to add fields to tables, queries, forms & reports.
 
1 - 1 of 1 Posts
Status
Not open for further replies.
Top