On Tue, 10 Nov 2009 19:26:58 -0800, ThriftyFinanceGirl
You could create a query with unique records using the DISTINCT
keyword (or set the Unique Values property of the query). Then create
a second query based on the first one, and use the Count function:
select count(*)
from myTable
Actually I have three tables... Reports... Versions... Runs.... and I need to
know how many users there are for a version, but the users are attached to
the Runs table, so I have a single user for each run, but I don't need to
count the runs, I need to count the distinct users. Thanks!
OK, I think I see where you are coming from. Did you
resolve your problem or was there a follow up question?
--
Marsh
MVP [MS Access]
Actually I have three tables... Reports... Versions... Runs.... and I need to
know how many users there are for a version, but the users are attached to
the Runs table, so I have a single user for each run, but I don't need to
count the runs, I need to count the distinct users. Thanks!
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.