populating pivot table data

[Guest]

I have a table with 3 fields. Expense Type, Accouting,
Management. Given an expense type, it stores costs for
accouting and management in the respective fields.

I would like to use the same data but create a table with
Expense type, Department (with
values "Accounting", "Management", etc) and Cost.

How do I go about it?

Thanks

 

[Jeff L]

I assume you do not want to just make the new table and
type in all the old data

Easiest is to make the new table, and write two temporary
append queries to populate the new table from the old.

First I would set the Expense Type and Department fields
as a multiple Key so you don't get any duplicates.

Then just append the Accounting Expense Types and costs
first and the Management Expense types second.

For the department column, just call out the name of the
department explicitly Ex. Department: "Accounting"

Best Regards,
Jeff
labarj at yahoo dot com