functions on queries

  • Thread starter Thread starter andrew
  • Start date Start date
A

andrew

Hello!
I don't know if this is possible w/o SQL, but this is what
I want to do:

I have a coordinate system entered in, and I want to
define a region in a query. For example, for the "X
coordinate" field, I want ">= 0 And <=3"

But for the "Y coordinate" field, I want something like "<=
([x coordinate].
)", which will evaluate the
statement at every point between x=0 and x=3, and if the

Thanks so much!
Andrew
 
Hi,


It seems you did not complete your message.

In the criteria, under field Y, add :

<= [x]

if x is the field name. You may not have to use [ ] around it....just be
sure Access does not add quotes around your x when not using [ ]... it does
think you mean the literal "x", not the field name, sometimes...



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top