If statement for Access query

[ac98]

Could someone please help me... I need to create an If statement, but don't know how to write it... Please note all the dates are in seperate columns. Not sure if that matters.

If “sale date” is between or = to “start date” and “end date” then include gross sales, if not then leave null?
Is this even possible?

I'm also doing this in the design query, not SQL statement. I'm not that advanced yet.

 

[Kiwiman]

the if statement in access is actually an iif statement.

Try using the expression builder to help build the expression.

The expression will be something like:

iif( [Yourtable]![saledate] >= [Yourtable]![startdate] and  [Yourtable]![saledate] <= [Yourtable]![enddate] ,[yourtable]![Gross Sales],Null)

 

[ac98]

Thank you soo much, that worked perfect!!!!! I really appreciate it!