Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"greater than" and anything "less than" in report. 1

Status
Not open for further replies.

lars7

Technical User
Aug 16, 2005
817
GB
Hi,
Would it be possible to only show a date in a column if it is "greater than" and anything "less than" to be blank. I want a start date for staff to appear only if it's ">01/10/04" if it's less than that I would like the record to appear but the start date to be blank.
 
=iif([fldNme] > #date#, [fldNme], "")

or something like that...

--------------------
Procrastinate Now!
 
Hi Crowley16,
Exactly like that thanks.

Tom.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top