B
Brennan
Hello all,
I have a dynamic form which displays a query in a list box on the form. I
have the criteria for the query linked to two other list boxes. So If I want
to see the result for a particular date, person or both, I can simply click
on that person or date in the listboxes and it will update the main query.
I want to be able to see an aggregate view of the data, but it will only
give me information when I select a person or date. I tried including a blank
cell in the person or date listboxes in hopes that it would create a blank
value in the criteria fields, but that didn't work.
How can I get the query to update with total results? Thanks for the help in
advance.
Brennan
I
I have a dynamic form which displays a query in a list box on the form. I
have the criteria for the query linked to two other list boxes. So If I want
to see the result for a particular date, person or both, I can simply click
on that person or date in the listboxes and it will update the main query.
I want to be able to see an aggregate view of the data, but it will only
give me information when I select a person or date. I tried including a blank
cell in the person or date listboxes in hopes that it would create a blank
value in the criteria fields, but that didn't work.
How can I get the query to update with total results? Thanks for the help in
advance.
Brennan
I