BETWEEN 1

[hitechboy78737]

Isn't there a "BETWEEN" statement in Access?

ie. fldDate BETWEEN xdate AND yDate

What is the proper syntax?

Thanks!
Kevin Howell

 

[HitechUser]

How's this...

Oracle SQL>
select count(alcohol_24hr) "Number drinking 5-10 units"
from VICTIM
where alcohol_24hr between 5 and 10;


Access
using aggregate function in a field
field number drinking 5-10 units:count(alcohol_24hr) alcohol_24hr
sort
show X
criteria between 5 and 10
or

SELECT Count([alcohol_24hr]) AS [number drinking 5-10 units]
FROM victim
WHERE ((victim.alcohol_24hr Between 5 And 10))
WITH OWNERACCESS OPTION;


Hey I can't take credit for this.. Found on Web.

Hope this helps..

Good Luck...

 

[HitechUser]

Okay fine.. Then how about right here on this site..

http://www.tek-tips.com/viewthread.cfm?qid=560260

Good Luck...