Query Help VERY BASIC

[nparrillo]

Folks,



I have two fields that I am basing a query off of.

1. Latitude
2. Longitude

Thus they are represented as numbers EX: 28.644856

I want a query that yield a name if it is located between lat/ long values

Example: I want it to say Jack when it is between Latitudes of 28.06546 and 28.754 and also between longitudes of -98.456 and -98.245

Thanks!

[nparrillo]

I have tried IIf states which seem to be working with only the latitude but as soon as a try the "and" with the longitude nothing appears

[kennejd]

IIF([Field] between 28.06546 and 28.754 and [Field] between -98.456 and -98.245,'Jack',0)

[nparrillo]

THat worked THank you! what if I now wanted to incorrperated or statements so I could have it yield multiple names with different lat/long betweens?

[nparrillo]

CLOSE TO LEASE: IIf([Surface Latitude] Between 28.613712 And 28.9567025 And [Surface Longitude] Between -98.7526974 And -98.343918,"SIMMONS"),IIf([Surface Latitude] Between 28.5282072 And 28.8416042 And [Surface Longitude] Between -98.474332 And -98.1189577,"HEARD")

why does this not work? it works fine if I just leave the first iif statement in alone, however once i add the extra iif, all i get in return are -1's...

[ssanfu]

You didn't nest the IIF() functions correctly.


Start with

IIF(condition , True , False )

then add the second IIF() function:

IIF(condition , True , IIF(condition , True , False ) )

Now add the terms:

IIF(([Surface Latitude] Between 28.613712 And 28.9567025) And ([Surface Longitude] Between -98.7526974 And -98.343918), "SIMMONS", IIF(([Surface Latitude] Between 28.5282072 And 28.8416042) And ([Surface Longitude] Between -98.474332 And -98.1189577), "HEARD", "Not Found" ) )