Reports and required data

  • Thread starter Thread starter Kathie G via AccessMonster.com
  • Start date Start date
K

Kathie G via AccessMonster.com

Hi all,
I have a report that should pull an error based on certain field not being
populated. How is the best way to do this?
 
Kathie

"... pull an error ..." What do you mean?

"... certain field not being populated." What do you mean? A field on a
table with no values throughout the table? A field/control on a form with
no value entered?

"I have a report..." Have you already created it, or are you looking for
how to do it?
 
Kathie G via AccessMonster.com said:
Hi all,
I have a report that should pull an error based on certain field not being
populated. How is the best way to do this?

It SOUNDS like you want a Query with a criterion of

IS NULL

on the field in question. This query will retrieve all records where the
field is empty. You can then create a report (an error report??) based on
this Query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top