I have created a report from a crosstab query, the column headings of 

which are actual dates. The report was created with the wizard, and the 

first time it was run, it worked fine. Two weeks later, i.e. when the 

dates have moved on two weeks, the query has the correct data, but the 

report won't run - it says it can't find the old dates. How can I update 

both the headings and the data in the report to reflect the new data in 

the query?

Richard Taylor

In a similar situation I designed a report with unbound text boxes 

for headings and detail and then I used (extensive I must confess) 

vba code (behind the report) in order to fill with values the boxes.



--- Richard Taylor <richardt@g...> wrote:

> I have created a report from a crosstab query, the column headings of

> 

> which are actual dates. The report was created with the wizard, and

> the 

> first time it was run, it worked fine. Two weeks later, i.e. when the

> 

> dates have moved on two weeks, the query has the correct data, but

> the 

> report won't run - it says it can't find the old dates. How can I

> update 

> both the headings and the data in the report to reflect the new data

> in 

> the query?

> Richard Taylor

>





=====

Visit www.alef.gr, greek science fiction, interactive site.



Entropy is increasing faster by burning books (Manolas M.)

> In a similar situation I designed a report with unbound text boxes 

> for headings and detail and then I used (extensive I must confess) 

> vba code (behind the report) in order to fill with values the boxes.

> 

> --- Richard Taylor <richardt@g...> wrote:

> > I have created a report from a crosstab query, the column headings of

> > 

> > which are actual dates. The report was created with the wizard, and

> > the 

> > first time it was run, it worked fine. Two weeks later, i.e. when the

> > 

> > dates have moved on two weeks, the query has the correct data, but

> > the 

> > report won't run - it says it can't find the old dates. How can I

> > update 

> > both the headings and the data in the report to reflect the new data

> > in 

> > the query?

> > Richard Taylor

> >

> 

> 

> =====

> Visit www.alef.gr, greek science fiction, interactive site.

> 

> Entropy is increasing faster by burning books (Manolas M.)

> 

I'm sorry if I'm missing something in your reply, but where can I read 

some code to fix the problem, especially if the code is extensive?

Richard Taylor.