Exclude entry when certain field is blank

[Guest]

In 2000, when running my report I need to leave out all entries when a
certain date field is missing data.

 

[Guest]

My apologies, that should be to leave out only the entries with the missing
date field.

 

[Lynn Trapp]

Do you simply want to make certain fields invisible if the date field is
NULL? If so something like this should work.

If IsNull(Me.YourDateField) Then
Me.SomeField.Visible = False
Else
Me.SomeField.Visible = True
End If

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

Lynn, thanks for your reply. Maybe I should have placed this question under
New Users for my sake. In this report each record has 13 fields one being
named "proj-date". I would like the entire record to be invisible if the
proj-date field has no data.
Thanks again.

 

[Lynn Trapp]

Well, in the Format Event of the detail section of your report, you want to
put code similar to what I posted below but add ALL the fields to the If
statement.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Vincent Johns]

Lynn, thanks for your reply. Maybe I should have placed this question under
New Users for my sake. In this report each record has 13 fields one being
named "proj-date". I would like the entire record to be invisible if the
proj-date field has no data.
Thanks again.

:

Since this is a Report, another approach would be simply to include in
the report only the records with non-null Date fields. That could be
done by making the data source of the Report be a Query with a
definition something like this:

SELECT [Mailing List].*
FROM [Mailing List]
WHERE ((([Mailing List].proj-date) Is Not Null));

Then, if only 5 records have "proj-date" values, only those 5 records
are in the report, and no fields need to be made invisible.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.