Query Criteria

  • Thread starter Thread starter mxinter
  • Start date Start date
M

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
 
Hi,

put the following into the criteria for the field:

Like "9*"

The * character is a wildcard.

hth

chas
 
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
 
Back
Top