How to have one field be tied to multiple fields?

N

Norm

I need to track how many "New Households" my company brings in on a daily
basis and what products the "New Household" buys. I built 2 tables: a
customer table that included a place where my employees would input a "1" if
a customer was a new household & a product table to enter in the products
sales & amounts.

I used these two tables as forms with the "product" table being a subform to
the "customer" table. My problem is when I pulled a query for new
households, it was marking each product a newhousehold customer opened as a
new household giving me too many new households. Ex: If I inputted Joe Smith
as a new household and he opened 4 new products, my query would say I have 4
new households when really I have 1 new household. I'm I not pulling the
query correctly or do I need to input some kind of code to recognize what I
need. I am using Access 03 & have only been using it for little more than 2
months.

Please help. Thank you.
 
K

KARL DEWEY

You need to post the SQL of your queries that feed the form/suform so folks
can see what you did.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top