Hi, I am using a modified Microsoft template (Desktop Call Tracker) i have a "Customers" Table, which contains:
ID Auto Number
Company
Last Name
First Name
Job Title
Address
City
Area
Post Code
Country
How can i do a search for customers in a certain "area" of with a similar "Post Code"
For example i want to search for all customers in the "Area" York or Birmingham
Or
I would like to search for all customers with a "Post Code" beginning with DE (Full post code would be DE45 6GG)
And from this can i produce a report
Thanks for any help