Reporting Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a summary report that includes a date field. However
only some of the fields are populated. Is there an if then statement in a
queery that will only admit the fields with a date?

Thanks,

Neal
 
Neal said:
I am trying to create a summary report that includes a date field.
However only some of the fields are populated. Is there an if then
statement in a queery that will only admit the fields with a date?
Click to expand...

I'm not sure what you're looking for, exactly, but you can certainly set
your report's recordsource query to include only those records WHERE
[YourDateField] IS NOT NULL .
 
You must log in or register to reply here.

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

Report Help 1
Report help 8
Adding a field to a subquery 1
Can't create a report from my query in Access 1
Basing Report on Crosstab 3
Running Query on memo field - character limit 4
Insert Date into Field2, the first Time Field1 is Populated with Dataon Form 2
Combine Text Fields 3

Back
Top