Re: crosstab qry as report source breaks Access2007

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks to both of you for the info - I assumed it was an Access 2007 issue
because the 2003 versions were running just great. I can make a pretty easy
fix - I can name my columns because the reports are designed for current year
and previous year columns of data only. Then I can change my two column
headings in the report to be lable fields to display the selected year and
previous year from the Report Selection Form.

Thanks again

Duane Hookom wrote:
Allen,
That solution is one I always recommend for date intervals since dates are
actually numeric. The one I had in mind is hosted over at Roger's site:

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Cross%20Tab'

This solution uses much less code and is much more efficient than the
solution that assigns control sources at run-time.

Don't tease, Duane! :-)

[quoted text clipped - 37 lines]
of?
Any suggestions appreciated.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200708/1

.

Relevant Pages

  • Re: ! Help on designing report managment screens for an app
    ... criControlName (controls on a main report selection form) ... tblReportCriteria (one record for each filtering control used on each ... My report selection form has a list box of all the available reports. ... some controls are enabled or disabled based on ...
    (microsoft.public.access.reports)
  • Access hangs when saving report
    ... I have a report which needs to be programmatically modified at runtime before ... All my reports are driven by a report selection form (allowing me ... Set oReport = Reports ... DoCmd.Close acReport, strReportName, acSaveYes ...
    (microsoft.public.access.reports)
  • Re: Using WHERE when using SendObject to Email in Outlook
    ... there is 1 report selection form from which many ... types of reports at once from the report picker form. ... Thinking out loud now...once a user selects the criteria in the report ...
    (comp.databases.ms-access)
  • RE: Transpose data in a report-Field values broken down to separat
    ... "Duane Hookom" wrote: ... The main report record source I suggested earlier would limit the report to ... Microsoft Access MVP ... have any gift records displayed in the report. ...
    (microsoft.public.access.reports)
  • Re: Passing a value from a form to a Reports SQL stored procedure
    ... Duane Hookom wrote: ... MS Access MVP ... second page of my report ... Dim strVersionID As String ...
    (microsoft.public.access.reports)