Ask Your Question

Create report from filter in form [closed]

asked 2014-03-23 15:43:49 +0100

Jaypee gravatar image

updated 2020-07-20 11:34:52 +0100

Alex Kemp gravatar image

I want to create a report from a filter made through autofilter in a form in base. Is there a way to do that?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 08:46:31.967556

1 Answer

Sort by » oldest newest most voted

answered 2014-03-24 01:16:57 +0100

frofa gravatar image

As far as I know, the auto-filter form control just 'auto-generates' an SQL QUERY 'behind the scenes' so to speak. But I think the only way to use it in a report is to re-create that query either in Design View or SQL View or use the query Wizard. Once you've got your query working (from the query list), you can use it in your report. You can also write an SQL query in the report source data properties directly (choose CONTENT TYPE SQL command and enter your query in CONTENT below).

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-03-23 15:43:49 +0100

Seen: 1,098 times

Last updated: Mar 24 '14