M
Mark
I think I asked the question improperly last time. I'm very new to
Access so please bear with me.
I have a half dozen or so tables containing different products.
I also have a table containing my users.
Each of the products table has a field titled 'username' .
There may be 0 occurences of a username in the product tables or there
may be many occurances of a username spread out through one, several, or
all products tables.
What I really need to do is figure out the SQL to look through the half
dozen or so products tables to count how many times a given username
occurs.
I'm doing this with ASP, and I can write the code to loop thruogh the
records but can't figure out t he easy way to check all tables with one
select statement, I really don't want to write 6 Select Statements and
keep accessing the Access DB if it's not nessecary.
Is there an easier way?
Mark
Access so please bear with me.
I have a half dozen or so tables containing different products.
I also have a table containing my users.
Each of the products table has a field titled 'username' .
There may be 0 occurences of a username in the product tables or there
may be many occurances of a username spread out through one, several, or
all products tables.
What I really need to do is figure out the SQL to look through the half
dozen or so products tables to count how many times a given username
occurs.
I'm doing this with ASP, and I can write the code to loop thruogh the
records but can't figure out t he easy way to check all tables with one
select statement, I really don't want to write 6 Select Statements and
keep accessing the Access DB if it's not nessecary.
Is there an easier way?
Mark