By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,560 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,560 IT Pros & Developers. It's quick & easy.

Counting Records

P: n/a
I have a query which selects a number of names from a table, which
abide with the criteria. I then want another query to select where the
names appear more than three times when the previous query is run,
would i use the count function and how would i go about it? Cheers for
any suggestions

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Go to the Query tab of the database window and click on New. Use the Find
Duplicates Wizard to create a second query based on the first query. After
the wizard creates the query, open the query in design view and put the
following expression in the criteria of the NumberOfDups field:
3 You don't need to run the first query first. Running the second query will
get the names you want.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
<te**********@hotmail.com> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com... I have a query which selects a number of names from a table, which
abide with the criteria. I then want another query to select where the
names appear more than three times when the previous query is run,
would i use the count function and how would i go about it? Cheers for
any suggestions

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.