Pass on a form filter by example to a query

T

Tom

I'm trying to create a form that I can filter and then
pass this filtered dataset into a query to get
totals/averages. I call the query from a button on the
form.

Can this be done?

thanks!
 
A

Albert D. Kallal

Where is the results of the query to go?

I can't imagine you just want a query? Do you not want a report?

Just use the filter property of the form when you open the report?

docmd.OpenReport "YourNiceReport",acViewPreview,me.Filter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help creating a search form in Access XP 0
Sorting and filtering text 0
filtering a form based on a filter on an open form 2
Incone & Expenses Statement 0
Request Form - Alert Team Member 0
Using DSUM to get running total on a filtered form 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
QBF & Query Malfunction 0

Top