Report Problem

[ajentp]

Hi to All,

First, I will thank all of you who has contributed this forum as I learned a lot by just going through different posts. Now I have a question, and I am really counting on you guys.

I am trying to make a report format for the database attached. The database is a financial tool to calculate Fixed and variable cost for a company. All the costs are entered monthly basis. Variable costs (COGS, Marketing, Postage) are entered and sub-categorized based on Product1 to Product9 (category Table). Income is also sub categorized based on Product1 to Product9.

Now I am trying to make a report in the Report or Form format where user can list down in vertical columns all the above variable cost monthly based as well as income based in accordance to product header.

Such as
July 2008
Product 1 Product2 ....... .......product9
Income Income Income
COGS COGS COGS
Marketing Marketing Marketing
Postage Postage Postage

I am new to Access. so I will really appreciate as much explanation as possible.

Thanks & Regards to all.

 

[stopher]

You can use a cross-tab query but first you need to create a query to pull all your tables together. Something like this:

SELECT "income" AS Type, Categoryid, [Sale] as myValue
FROM Income
UNION select "cogs" as Type, Categoryid, [cogs] as myValue
from COGS
etc.... for each table type

Then you can create a cross-tab query based on this query.

hth
Chris