Moving data in a row to a column

[JulieD]

Hi Scott

create a crosstab query (query object section, click on "new" button, choose
Crosstab query - put the names as row headings, the fund as column headings
and the SUM of Amount as the data), Save the query.

then if you use the report wizard to build a report based on this crosstab
query you should have what you're after.

Hope this helps.
Regards
JulieD

 

[Scott]

What I want to do is hard to explain in a short sentence
so bare with me.

I have a table with a NAME column, AMOUNT column, and
FUND column. In the FUND column you can have three
different entries. Lets say those entries are GENERAL,
CAPITAL and OTHER. As you enter data into the table each
NAME and AMOUNT will be assigned to the proper FUND as
outlined. Now in my report I dont want columns of
NAME,AMOUNT AND FUND. I want columns of GENERAL, CAPITAL
and OTHER with the amounts underneath.

Anyone have any ideas?

 

[Scott]

I've done that and it's good for some applications but I
kind of wanted to see the each AMOUNT per NAME not just a
SUM of the amounts. In my report I created Text boxes
with IIF statements in them to do what I want but for
some reason Access will not let me use the SUM feature on
those Text boxes in the report.

 

[Marshall Barton]

What I want to do is hard to explain in a short sentence
so bare with me.

I have a table with a NAME column, AMOUNT column, and
FUND column. In the FUND column you can have three
different entries. Lets say those entries are GENERAL,
CAPITAL and OTHER. As you enter data into the table each
NAME and AMOUNT will be assigned to the proper FUND as
outlined. Now in my report I dont want columns of
NAME,AMOUNT AND FUND. I want columns of GENERAL, CAPITAL
and OTHER with the amounts underneath.

If a crosstab doesn't do what you want, try creating a group
(Sorting and Grouping in the View menu) on the Fund field.
Then set the report to have 3 columns (File - Page Setup
menu) with Down then Across snaking. You can use the group
header's ForceNewPage property to get the different Funds to
start at the top of a column. This will get kind of tricky
if you have a column with more items than will fit on a
single page.

 

[Scott]

This might be interesting, Thank you!

-----Original Message-----


If a crosstab doesn't do what you want, try creating a group
(Sorting and Grouping in the View menu) on the Fund field.
Then set the report to have 3 columns (File - Page Setup
menu) with Down then Across snaking. You can use the group
header's ForceNewPage property to get the different Funds to
start at the top of a column. This will get kind of tricky
if you have a column with more items than will fit on a
single page.