Create a multiple parameter search form for a query
I need to figure out how to create a user interface to search a query,
but here's the bad part...I need to account for criteria on at least 7
of the fields. Here's what I'm thinking I need to do:
Create an unbound form with unbound fields for all 7 of the fields in
the query. Then in the query create parameters that refer to those
fields.
But it's not that simple because the user needs the flexibility of
filling in as many or as few of the fields as they want. For example,
they may have "account number", a "customer agent number" and a "date
opened" and an "account type" to search by, or maybe they want to see
all accounts of a certain type only.
Is there any easier way to do this? All I can picture is writing lines
and lines of criteria for all the combinations of "ANDs" and/or "ORs"
that this would require. If there's a different road to go down, in VB
or something, I'm all for it, anything that could be cleaner than
this...
.
Relevant Pages
- Re: Query is not fast
... How could you possibly do be doing a grouping and sorting on that data as ... 000100000042xxx Account Maintenance ... Thus we want to have the above two columns, then you can do a query to Group ... by each account type, and we'll be able to use high speed indexing for this ...
(microsoft.public.access.queries) - Re: Adding Information to a Table
... Add two fields to SCT to contain the new data. ... Use an update query to populate the new fields that looks like the following ... == Join Account number to Account number ... I took all the account numbers from this table and looked up their "account types" and "account type descriptions" in another system. ...
(microsoft.public.access.queries) - Re: Adding Information to a Table
... Use an update query to populate the new fields that looks like the following ... UPDATE SCT INNER JOIN MQ ... == Join Account number to Account number ... types" and "account type descriptions" in another system. ...
(microsoft.public.access.queries) - RE: Display queried records with Null values (null recordcount)
... tables related to Assets and Transactions tables in the query, ... since AssetID from tblAssets is a foreign ... The query would return multiple rows per account, ...
(microsoft.public.access.gettingstarted) - RE: How to Retrieve and diplay the details in the form
... query for the main form. ... "naveen prasad" wrote: ... but when i change the account number the appropriate fields are not changing. ... and get the values of d1 and display in other fields in the form. ...
(microsoft.public.access.queries) |
|
