Total query on filtered Form

[diegomarino]

hi,
i have a form that has a query as recordsource and that i filter through code.

I'd like to make a report to show aggregated data, like that:

[CODE]Select Position, company, Count(position) FROM ----THE RECORDSOURCE FILTERED OF THE FORM --- GROUP BY position, company/CODE]



is there any way?
thanks

[Welshgasman]

Use the form filter as the where clause of a query.

[diegomarino]

that did the trick! thanks