Show If

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

I have the following fields in my table & query:

JobNo (primary key, query paramenter)
BegDate
EndDate
LeadDate

When a user runs the query and types the JobNo, I always
want the record to show. But, if the LeadDate is not
between the BegDate & EndDate I want that field in the
query to be blank. Is there a way to do this?

Thanks much,
Alex
 
I figured this out by using an expression:

LeadTimeDate: IIf([LeadDate]>=[BegDate] And ([Projects].
[LeadDate])<=[EndDate],[LeadDate],"")

Thank you
 
Back
Top