RE: Report Filters

A belated thanks to DuncanG for his sample Q&A database. It wasn't quite
what I had in mind, however. The functionality I want is so basic, simple
and straight forward that I can't believe that it's not "built" into Access.
In Lotus Approach, I could just chose a report design option that limited the
records appearing in a report to the most recently selected subset of the
table. Do I truly need to use an applet (re: the Duane Hook message) or to
come up with some complicated macro employee an advanced filter???? At the
moment I'm filtering by form, cutting and pasting the ad hoc forms filter
properties into the record filter properties. Truly UGLY! Again, am I
missing something I should have picked up in Access 101?

"DuncanG" wrote:

> Try the following url :http://www.fontstuff.com/access/acctut19.htm
>
> "Brook" wrote:
>
> > I am setting up a expense account database and want to create several reports
> > that are based on my Expense Table (I.E. Reconciled, Recimbursed, By Date,
> > etc), but I don't want to have to create separate reports/queries for each
> > report I want.
> >
> > Is there a way that I can set up a Pop Up Form that I can use to filter my
> > report based on my table and or query?
> >
> > thanks,
> > Brook
.

Relevant Pages

  • Re: Subqueries
    ... I wish I could upload the database so you could get a better idea... ... the record source for the report. ... the user chooses from a list of counties which populates the community list. ... Report with a filter. ...
    (microsoft.public.access.queries)
  • Re: Output filtered form into report
    ... Please make sure it is 2000 format -- Tools, Database Utilities, Convert ... ... MVP Microsoft Access ... The second suggestion still output all the data to a report even though I had applied a filter. ...
    (microsoft.public.access.forms)
  • Re: Filtering DataSets for Reporting Application
    ... you can create a temporary "ReportData" table that's unique to each report user or a common "rollup" table that's used by all report users. ... This can be done from the ASP application by executing a suitable query. ... I would prefer not to execute query after query against the database. ... I will be creating a custom Filter class. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: A really really simple report
    ... you use "database" with two different meanings. ... I assume you have a report with a record source of a table or query or SQL ... You can modify the record source to apply a filter or criteria. ...
    (microsoft.public.access.gettingstarted)
  • RE: Filtering from a Subform
    ... I CAN get the report to ... filter code in the command button is not working. ... > Northwind from the menus in the database window. ... This is linked to the PurchaseOrder table that uses POnbr as ...
    (microsoft.public.access.tablesdbdesign)
Loading