between two dates

L

Lila

I currently have the following expression in my query:

Sold After Disaster:
Count(IIf([Info_SaleDate]>#10/31/2003#,[Info_SaleDate],Null))

.... but I want to modify it so that instead of showing anything sold after
10/31/03, I want everything sold between 10/31/03 and 10/31/04

I just don't know the operator for between.

Thanks,

Lila
 
L

Lila

Sorry, answered my own question

Sold After Disaster: Count(IIf([Info_SaleDate] Between #10/31/2003# And
#10/31/2004#,[Info_SaleDate],Null))

Sometimes HELP actually does help!
 
R

Rick Brandt

Lila said:
I currently have the following expression in my query:

Sold After Disaster:
Count(IIf([Info_SaleDate]>#10/31/2003#,[Info_SaleDate],Null))

... but I want to modify it so that instead of showing anything sold
after 10/31/03, I want everything sold between 10/31/03 and 10/31/04

I just don't know the operator for between.
Click to expand...

Between #10/31/03# and #10/31/04#

(whoda thunk it?) :)
 
Top