Numerical values in queries

[cayham86]

Hi guys,

I have a bit of a problem I have a query which has both numerical and letter codes in them but I want to exclude the numerical codes from it.

Suggestions welcome

 

[plog]

Can you demonstrate your issue with data? Please provide 2 sets:

A. Sample data from your table(s). Include table and field names and enough data to cover all cases.

B. Expected result of A. Show us what data you expect to end up with when you run the query.

Again, 2 sets of data--starting and ending.

 

[CJ_London]

Sounds like you need to use the isnumeric function

where not isnumeric (myfield)

 

[cayham86]

Sounds like you need to use the isnumeric function

where not isnumeric (myfield)

How does that work??

 

[arnelgp]

you create a Query from your table:

add all your fields to the query.
then add a "calculated" column and add criteria to it:

Field: Expr: IsNumeric([CodeField])
Show: (unticked)
Criteria: False

 

[cayham86]

you create a Query from your table:

add all your fields to the query.
then add a "calculated" column and add criteria to it:

Field: Expr: IsNumeric([CodeField])
Show: (unticked)
Criteria: false

Thanks for the help ill try this later

 

[cayham86]

you create a Query from your table:

add all your fields to the query.
then add a "calculated" column and add criteria to it:

Field: Expr: IsNumeric([CodeField])
Show: (unticked)
Criteria: False

Can I do something similar for just numbers

 

[arnelgp]

change the Criteria to True

 

[cayham86]

change the Criteria to True

Anything from single codes to descriptions

 

[Gasman]

You are not helping yourself, with all these one liners.