C
ChuckW
Hi,
I have one table in my database called tblTransactions which has fields such
as TrxDate, CustomerName, ProductNumber, InvoiceDate, Qty and Amount. I
created a form that has a combo box that does a lookup of all companies in
the tblTransactions table. Using distinct, it lists all companies. Once
selected, the user can click on a report based on a query that gives all
transactions for that particular customer in the combo box. Most customers
have two accounts - a retail and a warehouse account. So an example of a
customer name would be "ABC Company - Retail" or "ABC Company - Warehouse".
Right now, the user can select one or the other and run the report. What I
want to do is to somehow create a customer roll up table that will list ABC
Company. The user can select this account and get all transactions for both
account (retail and warehouse).
Can someone help?
Thanks,
I have one table in my database called tblTransactions which has fields such
as TrxDate, CustomerName, ProductNumber, InvoiceDate, Qty and Amount. I
created a form that has a combo box that does a lookup of all companies in
the tblTransactions table. Using distinct, it lists all companies. Once
selected, the user can click on a report based on a query that gives all
transactions for that particular customer in the combo box. Most customers
have two accounts - a retail and a warehouse account. So an example of a
customer name would be "ABC Company - Retail" or "ABC Company - Warehouse".
Right now, the user can select one or the other and run the report. What I
want to do is to somehow create a customer roll up table that will list ABC
Company. The user can select this account and get all transactions for both
account (retail and warehouse).
Can someone help?
Thanks,