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

Check if a query returns rows? 1

Status
Not open for further replies.
Keph

Keph

Technical User
Oct 15, 2002
16
0
0
CA
I'm trying to find a way to check if a given query returns any rows. I can't seem to find anything like this in these forms or in the MS Access help files. Can someone point me in the right direction?

Thanks!
 
Sort by date Sort by votes
me![how many rows query returned] = dcount("field in query that will alwas have something", "query name")

This is right off the top of my head, but check it out and look into the dcount command...

there are other faster way's out there, but this will get you going i think...


--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.
 
Upvote 0 Downvote
Dcount looks like it's exactly what I'm looking for, thanks!
 
Upvote 0 Downvote
Glad I could help...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ziffer68
  • Locked
  • Question
Pass Through query to create an alias for DB2 member
Replies
0
Views
103
ziffer68
ziffer68
Moss100
  • Locked
  • Question
Vba code I can call from a query to reformat text
Replies
8
Views
138
Moss100
Moss100
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
181
Andrzejek
Andrzejek
aldi07
  • Locked
  • Question
update a front-end database with a new release using vba
Replies
5
Views
99
aldi07
aldi07
Moss100
  • Locked
  • Question
Make database appear as just a form
Replies
1
Views
57
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top