I should just get a hat with a big D on it and then everyone would recognise
me..
anyway...
I have a DB full of people and their details..
I'm trying to perform a query based on age.
so I have a form with two values..upperlimit and lowerlimit ( eg aged
between 25 and 30, but worked out in years so that upper limit gives a birth
year of 1974 and lowerlimit gives a birth year of 1979)
my query string looks like
strSQL = "SELECT * FROM users where ( (right(dob,4)) =>" & lowerlimit & "
AND " & " (right(dob,4)) =<" & upperlimit & ")order by key"
so..dob is the DB field for date of birth, I'm just taking the year from
this hence the right(dob,4) and looking for entries where the year of dob is
more than AND less than the search criteria
the error message I get is
Syntax error (missing operator) in query expression
I must be missing something obvious...
on a lighter note...I'm certainly getting there as I've managed to get most
of the queries working..just not this one....lol
thanks again