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

Running a saved query

P: n/a
Hi

I need to run a saved query and just need to know if there are any records
returned. Not interested in actual records. What is the easiest way to do
this?

Thanks

Regards
Nov 26 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"John" <Jo**@nospam.infovis.co.ukwrote in message
news:CZ********************@pipex.net...
Hi

I need to run a saved query and just need to know if there are any records
returned. Not interested in actual records. What is the easiest way to do
this?
A SELECT query I assume?

If DCount("*", "QueryName") 0 Then...

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Nov 26 '06 #2

P: n/a
Wow, so simple. Thanks.

"Rick Brandt" <ri*********@hotmail.comwrote in message
news:3O*******************@newssvr13.news.prodigy. com...
"John" <Jo**@nospam.infovis.co.ukwrote in message
news:CZ********************@pipex.net...
>Hi

I need to run a saved query and just need to know if there are any
records returned. Not interested in actual records. What is the easiest
way to do this?

A SELECT query I assume?

If DCount("*", "QueryName") 0 Then...

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Nov 26 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.