Query on Odd Values

[Tim]

Hey guys,
Quick question, I feel so foolish asking this but... I need help writing
this query.

fldCircut's values are 1-90 with duplicates and the format is Integer.

I'm trying to design this query and set the criteria for fldCircut to show
only odd values.

Thanks all.

 

[Sylvain Lafontaine]

First, it would be more appropriate to ask this question in a newsgroup
dedicated to either Access queries (m.p.access.queries) or to T-SQL (for
SQL-Server queries, m.p.sqlserver.programming).

In your case, I would be happy to answer; however, I don't know if you want
an answer for SQL-Server (and for which version of T-SQL) or for JET/Access
and more important, I absolutely don't understand what you mean exactly with
the expression "odd values".

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)