Queries

[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

 

[Fons Ponsioen]

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