Searching my Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that contains customer Names, Numbers, Notes, and Address info.
Thee is a form where I want people to be able to search by previously
menstioned fields.

My current solution is this. I have forms for different types of searching,
by address, by phone number and by name. These forms are connected to queries
and the query that has a bunch of [Form]![Formname].[textfield] and shows
results where fields match.

My problem is this. When I run the query it returns the wanted results but
does not list the relevant returns first and seems to return them in the
order they appear on the table. I am sure there is a better way to do this,
possibly with a little VBA but I don't know for sure what that would be.

Thanks for any help you can offer!

James O
 
Not sure what that last few sentences mean.

If you want to control the order of returned results, then set the grouping
and sorting in your form or set the sorting in your query.
 
James:

You would need to add references, to the previously entered data, to your
query. Thus you can be ever more specific in the data you return.

HTH

Sharkbyte
 
One way is to click in the field you wish to sort on and then click on the
icon A-Z or Z-A.
 
Back
Top