Re: Exclude entry when certain field is blank

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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



"dclarcq" <dclarcq@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9A174973-CC24-486B-A1F1-9FB87F7A8E83@xxxxxxxxxxxxxxxx
> In 2000, when running my report I need to leave out all entries when a
> certain date field is missing data.


.

Relevant Pages

  • Index entries do not group
    ... using Word 2003 I get strange results with index entries. ... It is strange, but some other 'report' entries are grouped as they ... Prev by Date: ...
    (microsoft.public.word.docmanagement)
  • Exclude entry when certain field is blank
    ... when running my report I need to leave out all entries when a ... certain date field is missing data. ... Prev by Date: ...
    (microsoft.public.access.tablesdbdesign)
  • Re: subreport question
    ... So me as an employee, the report would list all my entries ... Prev by Date: ...
    (microsoft.public.access.reports)
  • Summing totals in a query
    ... I have a query thats returns specific entries in a table with a few project ... I want the totals (preferably in a report) ... Prev by Date: ...
    (microsoft.public.access.forms)
  • RE: Remove duplicate entry in combobox
    ... When I open the unbound form, I get the single entries as opposed to the ... This is the first time I've ever worked with combo boxes and unbound forms. ... having the report based on a query where the user had ... Destination fields but could not get it set up properly. ...
    (microsoft.public.access.formscoding)