Queries

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

I have a data base of names, addresses, phone numbers
etc. The names are listed by surmame then first name i.e.
Peter, Smith.

What ever surname I put in criteria of the name field
then run the querie no results are shown. Why is this?
Have I done something wrong on not done something?

Many thanks for any advice.

Martin
 
From your description it is not quite clear how your query
is constructed and specially if your name field is
concatenated.
Try instead of entering a name, enter the following line
in the criteria;
=like *smith*
substitute a valid name for smith and make sure to inlcude
the asterisks*.
If you now see some result it seams to indicate that your
name is not exactly like you enter it in the criteria
Hope theis helps
Fons
 
Back
Top