Report from filtered Records Problem...

[robbo5000]

I have a database with over 100 fields. I have made the form which users can filter using the Filter by Form function.

The problem is, I want to create a report based only on the filtered records and for it to NOT include all the fields in the form/database. I have tried using the "me.filter" when calling the report through a button but I get "Enter Parameter Value" box when the user filters a field that is not included in the report.

Any help will be superb.

 

[Crowley16]

use a query to bring back the fields you want, and then base the report on that query...

--------------------
Procrastinate Now!

 

[robbo5000]

How will I do That?

 

[dhookom]

It's generally fairly easy to limit the records returned in a report. Finding a good argument for be able to limit the fields returned is rare.

Having 100 fields is about 65 more fields than I would expect to find in a well normalized application. Also, a desire to limit fields in a report is a red flag.

Do you really need to be able to provide published reports for users or will an exported query to Excel provide the required needs.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[robbo5000]

A query would do fine but I only need 3 of the fields in the output and need it sent by email. Is this possible?

 

[dhookom]

There is a custom query-by-form/adhoc report applet at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

You can output the results to many different formats. I haven't added the ability to send the results via email.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]