G
Guest
I am working on creating an access query to look up specific parts and
pricing from a large number of parts across several different tables. I am
using a series of six parameter queries that prompt the user for information
such an manufacturer, model number ect. My question is how do I prompt Access
to disregard the search parameters where no data is entered, but use all the
fields in which information is entered to populate a list of records? i.e.,
when the user enters a product type AND model number, it will use both pieces
of information, not just the first. Also, is there any way to configure a
query so that the user doesn't have to enter the exact record information and
Access will pull up the closest record(s)? i.e., If a model number is A123-4
and the user puts "A123", a list of parts with model numbers that begin with
A123 will arise. Any help that anyone could give would be much appreciated.
Thank you!
pricing from a large number of parts across several different tables. I am
using a series of six parameter queries that prompt the user for information
such an manufacturer, model number ect. My question is how do I prompt Access
to disregard the search parameters where no data is entered, but use all the
fields in which information is entered to populate a list of records? i.e.,
when the user enters a product type AND model number, it will use both pieces
of information, not just the first. Also, is there any way to configure a
query so that the user doesn't have to enter the exact record information and
Access will pull up the closest record(s)? i.e., If a model number is A123-4
and the user puts "A123", a list of parts with model numbers that begin with
A123 will arise. Any help that anyone could give would be much appreciated.
Thank you!