A
Annette
I would like to build a SQL statement that searches a table, based on
criteria, that would eliminated the requested field. For example, I
have about 9 fields that I would like to search upon. If the user
wants to search for all entries for a certain department, I would like
the SQL statement to be built using the department as a criteria, but
not to display the department in the listbox results. If they request
all transactions for the HR department, there is no need to display HR
over and over in the results listbox.
Is there an easy way to do this or do you have other suggestions? I
know the listbox size would have to be defined for the lenght of the
fields so maybe this is not a good option, but I see no sence in the
user asking for a specific user at a specific location and having the
location and user columns taking up space in the results form.
criteria, that would eliminated the requested field. For example, I
have about 9 fields that I would like to search upon. If the user
wants to search for all entries for a certain department, I would like
the SQL statement to be built using the department as a criteria, but
not to display the department in the listbox results. If they request
all transactions for the HR department, there is no need to display HR
over and over in the results listbox.
Is there an easy way to do this or do you have other suggestions? I
know the listbox size would have to be defined for the lenght of the
fields so maybe this is not a good option, but I see no sence in the
user asking for a specific user at a specific location and having the
location and user columns taking up space in the results form.