querying based on odd/even numbers

[czarjosh]

i Have a field that has numbers in (though they stored as text) I want to be able to pull just even or odd numbers? Can I do this?

 

[SkipVought]

Hi,

Even

Select * From MyTable Where MOD([MyField],2)=0

Odd

Select * From MyTable Where MOD([MyField],2)=1

Skip,
[sub]
[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it! [/sub]

 

[czarjosh]

will that even work, though the numbers are stored at text?

 

[PHV]

Take a look at the Val function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[czarjosh]

I am not familiar with the VAL function. Can somehelp me out with it?

 

[PHV]

From Skip's code:
Select * From MyTable Where MOD(Val([MyField]),2)=1

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[JonFer]

Isn't the syntax

([Field] Mod 2)=1

Also, it works on numbers stored as text without needing VAL() although if you have bad numbers then VAL returns 0 and so will MOD.

John

http://www.interautomateconsulting.com

 

[SkipVought]

JonFer,

You are correct. I assumed that the function would be similar to Excel, but it's the VB syntax, ([Field] Mod 2)=1!

Skip,
[sub]
[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it! [/sub]