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!

Number of Results

Status
Not open for further replies.
soupisgood84

soupisgood84

Technical User
Apr 17, 2007
45
US
I was wondering if there was a way to get a number of results in a query.
I am running a query by form and I want to know when it returns 0, or for that matter any number of results. Just wanted to know if there was a easy way to request this.

Thanks in advance.
 
Sort by date Sort by votes
Have a look at the RecordCount property of the DAO.Recordset oject.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
May also be interested in the functions
Count
DCount
and if using a report
the "NoData" event
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

monkeysee
  • Locked
  • Question
Combo Box - Limit results
Replies
1
Views
234
dhookom
dhookom
TomSalvato
  • Locked
  • Question
Getting the Monday date from a week number 1
Replies
2
Views
307
TomSalvato
TomSalvato
caykamanj1966
  • Locked
  • Question
Help With Search Form Results 2
Replies
15
Views
196
caykamanj1966
caykamanj1966
TrekBiker
  • Locked
  • Question
Spurious Change of Fonts
Replies
3
Views
193
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Hyperlink Text of a field
Replies
1
Views
123
caykamanj1966
caykamanj1966

Part and Inventory Search

Sponsor

Back
Top