M
michelle
is it possible to run a "make-table" query on the results
of a crosstab query?
what i'm trying to do is take the results of a query and
put it into excel. (there are actually many queries, and
the results of these queries need to go into the same set
of cells each time they're updated - this is a process
i'm trying to automate)
for example, i have a table with a date field
(mm/dd/yyyy) and an amount field. i create a crosstab
query by doing the following Month(Date), Year(Date), Sum
(Amount). In the crosstab query, Month is the Row
heading, Year is the column heading, and Sum(Amount) is
the value.
It'll look something like this...
Month 2000 2001 2002
1 $500 $600 $800
2 $560 $670 $870
3 $540 $300 $200
..
..
..
Is there a way to make the results of the query into a
table?
Thanks.
of a crosstab query?
what i'm trying to do is take the results of a query and
put it into excel. (there are actually many queries, and
the results of these queries need to go into the same set
of cells each time they're updated - this is a process
i'm trying to automate)
for example, i have a table with a date field
(mm/dd/yyyy) and an amount field. i create a crosstab
query by doing the following Month(Date), Year(Date), Sum
(Amount). In the crosstab query, Month is the Row
heading, Year is the column heading, and Sum(Amount) is
the value.
It'll look something like this...
Month 2000 2001 2002
1 $500 $600 $800
2 $560 $670 $870
3 $540 $300 $200
..
..
..
Is there a way to make the results of the query into a
table?
Thanks.