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

Checking Tables For Data

P: 8
Is there a way of running a query to check if there is any data in a table. What i need to do is check and see if any data at all has been submitted into the tables. In each table there are approx 30 fields and i don't want to list them all on a query as there are 2 x tables to check.
Is there some sort of query i could run to see if the table is empty or has data in it.

Thanks
Dec 6 '07 #1
Share this Question
Share on Google+
1 Reply


lee123
100+
P: 556
Yes there is in the criteria of your query you can put the "is null" and that will show you all the tables that are missing data. but when you enter the "is null" in the criteria, place it under the field you are checking. for instanct here is an example:

if your checking in a customer table to see if a customer doesn't have a phone number you would place the "is null" in that field (criteria) to check all the customers that have missing phonenumbers.

i think this is what your talking about.

lee123
Dec 6 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.