|
 |
access thread: Re: Report building problems
Message #1 by "Beverly Usher" <bUsher@h...> on Fri, 24 Aug 2001 14:09:38 +0100
|
|
I have a query based on a crosstab query and two other queries that total
the same data different ways. It runs fine and produces the right results.
However, whenever I try to build a report based on it, Access hangs up (I'm
in Access 97). I have tried to resolve it various different ways: I have
copied the SQL into a new query; I have deleted it, repaired and compacted
the database and copied the SQL into a new query; and I have build it from
scratch. I still cannot build a report on it.
Does anyone have any ideas on this???
Beverly
Message #2 by "AJ Prange" <ajprange@e...> on Fri, 24 Aug 2001 18:31:47 -0400
|
|
There probably is an elegant way to do that in VBA, but what I've done is
change the query to a "make table query", and report on that.
AJ Prange
Beverly Usher <bUsher@h...> wrote in message
news:96382@a...
I have a query based on a crosstab query and two other queries that total
the same data different ways. It runs fine and produces the right results.
However, whenever I try to build a report based on it, Access hangs up (I'm
in Access 97). I have tried to resolve it various different ways: I have
copied the SQL into a new query; I have deleted it, repaired and compacted
the database and copied the SQL into a new query; and I have build it from
scratch. I still cannot build a report on it.
Does anyone have any ideas on this???
Beverly
Message #3 by "Sanna Korpela" <sanna.m.korpela@l...> on Mon, 27 Aug 2001 11:06:28
|
|
Hi Beverly!
Have you tried creating an empty report and then making subreports in it,
each including one signle query. E.g. Separate subreport for detailed info
and separate for summary? I have made reports including many different
view to data that way and I think it might work on you too.
Sanna
> I have a query based on a crosstab query and two other queries that total
> the same data different ways. It runs fine and produces the right
results.
> However, whenever I try to build a report based on it, Access hangs up
(I'm
> in Access 97). I have tried to resolve it various different ways: I have
> copied the SQL into a new query; I have deleted it, repaired and
compacted
> the database and copied the SQL into a new query; and I have build it
from
> scratch. I still cannot build a report on it.
>
> Does anyone have any ideas on this???
>
> Beverly
>
|
|
|
View Cart
