Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Count of more than one record

Status
Not open for further replies.
CarrieR

CarrieR

Technical User
Nov 9, 2001
60
0
0
US
Hello

How would I, in a query, count if more than one record exists for a field? (Text field called LastName.) I have tried using DCount>1, nothing seems to work.

Thanks
 
Sort by date Sort by votes
Does not work. Get error message "Can't have aggregate function in WHERE clause.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JimStrand
  • Locked
  • Question
Crosstab query - returning 1 record per week instead of 1 record
Replies
1
Views
132
JimStrand
JimStrand
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
183
TheresAlwaysAWay
TheresAlwaysAWay
serino
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
303
serino
serino
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
79
Andrzejek
Andrzejek
mhshane
  • Locked
  • Question
Query to find keywords in description field and give count
Replies
4
Views
69
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top