Find number of records in a subset of large table

[Abinadi8]

I have been trying to create a temp Table of the subset desired; however, I find this does not work well if there are no records. then I get an error that I trap and report back as to what, when and where this happens. I would rather create a specified # records if the COUNT is 0.
I have been told that this possible within a query, is this true and if so could someone email me a quick example of how this is done. klnield@attbi.com
Email Subject should be: Access Query example as I tend to delete emails from people I don't recognize.

 

[JeremyNYC]

Abinadi8,

This is a public group. We work together to answer questions so that everyone will learn. You cannot expect people to send e-mail to you. And to ask someone to use a particular subject is pretty close to rude.

You can do what you want fairly easily. You don't want to use make-table queries, as they will cause lots of file bloat. Look in help under totals queries and you'll find what you need.

Jeremy =============
Jeremy Wallace

http://www.AlphaBetCityDataworks.com

Designing, Developing, and Deploying Access databases since 1995.