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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Count One instance of Dulicate Records

Status
Not open for further replies.
agray7501

agray7501

IS-IT--Management
Joined
Feb 21, 2002
Messages
3
Location
US
I have a table that unfortunately has duplicate values that correspond to an application number. I would like to Count the application number only one time. Any help is greatly appreciated..
Al
 
Sort by date Sort by votes
How about....

Set db = currentdb
Set rs = db.OpenRecordset("SELECT DISTINCT RecNbr FROM Table")
intX = rs.RecordCount


Randy
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Question Question
Duplicate Records in DataSheet View
Replies
5
Views
1K
Andrzejek
Andrzejek
TrekBiker
  • Locked
  • Question Question
Spurious Change of Fonts
Replies
3
Views
711
dhookom
dhookom
TinaS
  • Locked
  • Question Question
Quick one I think - question about Properties window in Form Design view
Replies
1
Views
496
dhookom
dhookom
caykamanj1966
  • Locked
  • Question Question
Hyperlink Text of a field
Replies
1
Views
380
caykamanj1966
caykamanj1966
JayRo71
  • Locked
  • Question Question
Select records on subform using a combo box with a twist
2 3
Replies
56
Views
3K
JayRo71
JayRo71

Part and Inventory Search

Sponsor

Back
Top