J
Joseph
I have created multiple tables:
cust_tbl - list of customers(will not change)
prod_tbl - list of products (will not change)
bud_tbl - commitment level at the beginning of the year (will not change)
mon.spend_tbl - customer's monthly spend (will vary monthly)
I have a query that will combine the tables to provide a list of customers,
the customer's related prodcuts, the customer's commitment, the monthly spend
and the variance between the commitment and monthly spend.
How can I set up a form that will update the criteria in the query based off
a list of customers and products?
cust_tbl - list of customers(will not change)
prod_tbl - list of products (will not change)
bud_tbl - commitment level at the beginning of the year (will not change)
mon.spend_tbl - customer's monthly spend (will vary monthly)
I have a query that will combine the tables to provide a list of customers,
the customer's related prodcuts, the customer's commitment, the monthly spend
and the variance between the commitment and monthly spend.
How can I set up a form that will update the criteria in the query based off
a list of customers and products?