Using macro to open report based on empty field.

E

Ebbrecords

I have a report to create that extracts data from different tables and will
be generated with a macro. I want the data on the report to be based on if a
field in a certain table (date field) is populated. If the field is empty,
then I want that record (consisting of different fields in the different
tables) to appear on the report. If the date field is populated, then I do
not want them on the report.
 
S

Steve Schapel

Ebbrecords,

If I understand you correctly, the table that contains the date field in
question is part of the query that the report is based on. In the Criteria
of the date field in the query, enter:
Is Null
 

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

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Access MSACCESS - Sorting report based on field calculated in the report 0
How to filter report using macro based on selected option from query 0
Embedded Macro to return only active records 6
Access Access Report Works on One Machine but not Another 3
auto populate a field based on value of other fields 1
SetValue using macros 5
A Report, based on query, called from macro is prompting for param 1

Top