Morning,
Ive been converting/re-writing an old Lotus Approach database in Access. Im about 3/4's of the way through. Its been quiet a large project but I can finally see the finish line.
Some of the easiest things in Approach seem to be so difficult to achieve in Access, however, can someone assist me with the below.
I am simply trying to do a search in multiple fields. So for eg I might want to find all names 'Jones' which occurred after 24/05/20.
Or all customers in Manchester which do not have phone numbers.
Now in Approach the user would simply hit Ctrl & F and then the form fields would all be blank and you just types the criteria directly into the field and hit return (along with any operators such as '>' or '='. Any user with zero knowledge could do it.
In access I seem to have to create querys and forms etc but I am unable to predict what search the user might want to do. Surely there is a simple way of searching multiple fields for matching information?
Thanks in advance
Ive been converting/re-writing an old Lotus Approach database in Access. Im about 3/4's of the way through. Its been quiet a large project but I can finally see the finish line.
Some of the easiest things in Approach seem to be so difficult to achieve in Access, however, can someone assist me with the below.
I am simply trying to do a search in multiple fields. So for eg I might want to find all names 'Jones' which occurred after 24/05/20.
Or all customers in Manchester which do not have phone numbers.
Now in Approach the user would simply hit Ctrl & F and then the form fields would all be blank and you just types the criteria directly into the field and hit return (along with any operators such as '>' or '='. Any user with zero knowledge could do it.
In access I seem to have to create querys and forms etc but I am unable to predict what search the user might want to do. Surely there is a simple way of searching multiple fields for matching information?
Thanks in advance