Advertisement

08.07.2003 at 12:29PM PDT, ID: 20703196
[x]
Attachment Details

MS Access Report based upon Crosstab Query, dynamic column names in report

Asked by toverstreet in Microsoft Access Database, Access Reports

Tags: access, crosstab, dynamic, report, query

I currently have an crosstab query containing several pcs of data.  The Column heading is a date related to to some data being queried from outside Access (not relevant).

I am trying to write a report to display this data so I may distribute it.

My issue arrises in that the query column names are variable.  There are 8 columns representing the dates of the week's orders.  

IE if I run today the query column headings are: 8/1/03, 8/2/03, 8/3/03, 8/4/03, 8/5/03, 8/6/03, 8/7/03, 8/8/03

If I run the report next week the column headings would be: 8/8/03, 8/9/03, ..... , 8/15/03.

Can I get the report to use these column headings and change each week?

Note: VB is okay/preferred.Start Free Trial
 
Keywords: MS Access Report based upon Crosst…
Title
1 Crosstab to List
2 Crosstab subreport Problem
3 How do I create a crosstab report that …
4 crosstab in sql?
5 crosstab in sql
6 Column headings in crosstab queries
 
Loading Advertisement...
 
[+][-]08.07.2003 at 12:32PM PDT, ID: 9102703

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.08.2003 at 12:24AM PDT, ID: 9106242

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.08.2003 at 12:26AM PDT, ID: 9106249

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.08.2003 at 06:09AM PDT, ID: 9107811

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Access Database, Access Reports
Tags: access, crosstab, dynamic, report, query
Sign Up Now!
Solution Provided By: walterecook
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32