PDA

View Full Version : Problems with query


ABC123

M_Mowat
11-23-2002, 03:21 PM
Running a query with these conditions...
>=VAR->ASKC_First_number and
ASKC_Last_number gives me the first number and all numbers in between, but not the last number. What am I doing wrong?

Michael Mowat

ronwills
11-25-2002, 05:09 PM
I have found that when doing some queries this way, I would get the same results using =

Try the BETWEEN function. BETWEEN(field name, number 1, number 2)
I find that this always works and you can use alpha or numbers

BETWEEN(LastName, "Alpha", "Gamma") will give you everything from Alpha through Gamma.
BETWEEN(Amount, 100, 500) will give you all records where amount is 100 through and including 500.
BETWEEN(field name, var->AscC_FirstNumber, var->ASKC->LastNumber) would work with the ask field.

Also be careful of using the Var->ASKC (which is for character fields) and the Var->ASKN (which is for numbers)

Ron Wills
Small Business Technology, Inc.
ronwills@sbtech.us