richardbarlow
asked on
Update query has to find all odd numners
I need an update query to modify all records with odd numbers. The field containing the numbers is called TAG and they are all whole numbers.
How do I detect odd or even in a query?
How do I detect odd or even in a query?
Last Comment
ASKER
I'm getting a syntax error. Access doesn't like the %
I'm using this in SQL view:
SELECT tblCatalogue.TAG
FROM tblCatalogue
WHERE (((tblCatalogue.TAG%2)="1"
I'm using this in SQL view:
SELECT tblCatalogue.TAG
FROM tblCatalogue
WHERE (((tblCatalogue.TAG%2)="1"
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you - spot on
sorry, my code works on SQLExpress 2005 :) thought it works for you too :]
ASKER
worked great with the mod entry. now i have another question re odd/even which i'll post in a minute or so
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Select * from tablename where ((fieldName%2)=0) 'gets even numbers