Connecting Date Fields

  • Thread starter pandaw1 via AccessMonster.com
  • Start date
P

pandaw1 via AccessMonster.com

Hi,

I have 2 date fields in a query, and I want to only show the second date
field where it is equal to or after the first date field - could someone tell
me how to write that in the criteria?

Many Thanks.
 
R

Rick Brandt

Hi,

I have 2 date fields in a query, and I want to only show the second date
field where it is equal to or after the first date field - could someone
tell me how to write that in the criteria?

Many Thanks.
Click to expand...

AliasName: IIf([Date2]<[Date1], null, [Date2])
 
Top