not sure if this is possable

dawson321

Registered User.
Local time
Today, 06:42
Joined
Jun 6, 2010
Messages
29
hi,

I am wondering if it is possable to create a marco or query that will seach a table for blank feilds under a spesific heading, (such as "date paid in full"), and then bring the entire record up in a report.

Is it possable? if yes how can it be done?

thanks
 
In a query, for the field you want it in the criteria put the word NULL
This finds any records that have a blank value.
 
Do what namliam says

Then

Design a report based on the query previously created. Any report based on a query rather than a table will show only those records filtered through the query.

PS if you can do it on paper then in 99% of the cases the answer to

Not sure if this is possible is always

YES it is !!!
 
Last edited:

Users who are viewing this thread

Back
Top Bottom