between two dates

  • Thread starter Thread starter Lila
  • Start date Start date
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
 
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!
 
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?) :-)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count only those after a certain date 4
list a field based on a date 5
Between Dates Parameter Query 13
Converted from LINUX time ok, but having issues with the between date. 4
rst.findfirst not working with two conditions 6
Extract data within past 2 years of todays date 1
Return multiple records from a single entry. 2
Between...And Operators 3

Back
Top