A aronw Registered User. Local time Today, 18:23 Joined Dec 2, 2002 Messages 31 Dec 6, 2002 #1 URGENT between criteria Does anyone know the criteria (code) for a query that only displays the records that have values between what I specify Any Help TIA Aron Last edited: Dec 6, 2002
URGENT between criteria Does anyone know the criteria (code) for a query that only displays the records that have values between what I specify Any Help TIA Aron
J Jerry Stoner Guest Dec 6, 2002 #2 >YourLowerLimit And <Your Upper Limit >=YourLowerLimit And <=Your Upper Limit if you want to include the upper and lower limit This assumes numbers, for text surround values with quotes
>YourLowerLimit And <Your Upper Limit >=YourLowerLimit And <=Your Upper Limit if you want to include the upper and lower limit This assumes numbers, for text surround values with quotes
A aronw Registered User. Local time Today, 18:23 Joined Dec 2, 2002 Messages 31 Dec 6, 2002 #3 Thanks
