List of Enquiries from various towns

[Keith Burgess]

Hi,

I have built a very simple database to record names and contact details for all enquiries coming into our business. What I want to do is create a means whereby anyone in the company can enter a name of a specific town or county and the DB will produce a list of all enquiries that have originated from that town or county. Please write any replies in simple easy to understand steps as I am not an Acess expert. Any help would be appreciated.
Best regards
Keith

 

[statsman]

Create a query from the table that contains the data. Select the fields that contain the data you want in the query.

In the field that contains the names of the county/town, in the criteria section enter [Select town/county] square brackets required.

Run the query. It will prompt you for the town county to enter.

 

[Keith Burgess]

Hi Statsman,
Many thanks for your superb help on this it's working like a charm. All the best from an Access amateur in the UK.
Best regards
Keith

 

[Marlin47]

Hi,

I have built a very simple database to record names and contact details for all enquiries coming into our business. What I want to do is create a means whereby anyone in the company can enter a name of a specific town or county and the DB will produce a list of all enquiries that have originated from that town or county. Please write any replies in simple easy to understand steps as I am not an Acess expert. Any help would be appreciated.
Best regards
Keith

God's teeth ! I asked my IT consultant to do the above for me back in the early
1980's and he said it was difficult. I am astonished that nothing appears to have changed since then.

 

[Groundrush]

God's teeth ! I asked my IT consultant to do the above for me back in the early
1980's and he said it was difficult. I am astonished that nothing appears to have changed since then.

Anything is easy when you know how