Query Criteria

[mxinter]

Need to query out the total in certain fields where in one
of the field names in the database I want to consider only
those "Starting" with number 9............how would I do
this?

Your help is appreciated.........


Rgds,


mxinter

 

[chas]

Hi,

put the following into the criteria for the field:

Like "9*"

The * character is a wildcard.

hth

chas

 

[Terri]

In the criteria use "9*" this give all that start with 9
can also be used at the end i.e. "*9" would give all
ending in 9