M
mscertified
I have a form with 3 listboxes. Each listbox shows the results of a query
against the same table (which has around 100,000 rows) but with different
WHERE clauses. The WHERE clauses use columns that are not indexed (they are
dates).
listbox 1 shows open tickets opened today, listbox 2 shows tickets closed
today, listbox 3 shows open tickets that have not been emailed.
Is there any way to arrange this so that the form does not have to run 3
queries to populate these listboxes. Since listbox 1 and 2 both only look at
tickets opened today, I was wondering if they could somehow 'share' a query.
Maybe by having a hidden listbox that holds all the tickets opened today and
then listbox1 and 2 could somehow get and filter the data from the hidden
listbox?
against the same table (which has around 100,000 rows) but with different
WHERE clauses. The WHERE clauses use columns that are not indexed (they are
dates).
listbox 1 shows open tickets opened today, listbox 2 shows tickets closed
today, listbox 3 shows open tickets that have not been emailed.
Is there any way to arrange this so that the form does not have to run 3
queries to populate these listboxes. Since listbox 1 and 2 both only look at
tickets opened today, I was wondering if they could somehow 'share' a query.
Maybe by having a hidden listbox that holds all the tickets opened today and
then listbox1 and 2 could somehow get and filter the data from the hidden
listbox?