Re: Alternate sorting for Access report

Look at QueryDef in the Help file. You use a single query but change the
query's SQL programatically.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1175 users have come to me from the newsgroups requesting help
resource@xxxxxxxxxxxxxxx


<nn0410@xxxxxxxxxxxxx> wrote in message
news:1145975758.893961.181500@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have a report whose record source is a query. The query includes an
ORDER BY clause that sorts on a particular set of columns. I would
like to be able to run the same report with the same input data, sorted
on a different set of columns. Aside from copying (^C, ^V) the report
and changing the Record Source property in the new copy to another
query, is there an elegant way to accomplish this?

Thanks

Rick



.

Relevant Pages

  • Re: Too much data?
    ... > report on a single query? ... I am trying to create a report which provides analysis from our MIS ... >> The report covers 20 sections, each swction takes 4Cm of vertical space. ... >> A total of 20 different queries are involved. ...
    (microsoft.public.access.reports)
  • Re: Too much data?
    ... report on a single query? ... I am trying to create a report which provides analysis from our MIS ... > The report covers 20 sections, each swction takes 4Cm of vertical space. ... > A total of 20 different queries are involved. ...
    (microsoft.public.access.reports)
  • Re: indicate query values in form + relation
    ... yeses and nos. ... > Report ... > Brochure ... > Is this possible with one single query and one single form? ...
    (microsoft.public.access.forms)
  • Re: Export a reprot to Excel
    ... The export process will try to export the recordsource of the report. ... If you can create a single query based on the independent queries, ...
    (microsoft.public.access.reports)
  • Re: Need Resource Group in Visual Reports
    ... Because the machine I use with Project 2007 doesn't have Excel 2003 ... showing the same information as the Visual Report in Excel. ... When you said:"I've saved the resource usage cube and transferred ...
    (microsoft.public.project)