Reports and required data

  • Thread starter Kathie G via AccessMonster.com
  • 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?
 
J

Jeff Boyce

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?
 
J

John Vinson

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?
Click to expand...

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.
 
Top