Easy query problem

[nparrillo]

Folks,

Just am running a very basic query and for some reason I am having a problem.

What is wrong with the below IIF:

CLOSE TO LEASE: IIf(28.613712<[Surface Latitude]<28.9567025 And -98.7526974<[Surface Longitude]<-98.343918,"SIMMONS")

[nparrillo]

the query seems to run fine with no error messages, yet it is not yielding the "simmons" when it should

[kennejd]

Your conditions don't look right:

IIf(28.613712<[Surface Latitude]<28.9567025 And -98.7526974<[Surface Longitude]<-98.343918,"SIMMONS")

I'm not sure what you're testing, but that syntex is incorrect. Maybe a Between condition would work?

[nparrillo]

how do you do a between condition?