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)

 

[PieterLinden via AccessMonster.com]

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.

SELECT fldCircuit
FROM ???
WHERE [fldX]\2=[fldX]/2