Field values as columns ala Excel

[zfind]

Hi all, I have a small problem here that I don't know how to tackle.

Imagine your generic monthly revenue report in excel. You have the days of the month as columns and the values like gross revenue, net revenue, profit etc as rows.

I want to replicate this in Access using a table field week as the column headers and a few values as the rows. Is this possible in Access or is it something that really needs to be done in Excel?

 

[namliam]

Anything is possible anywhere...

I think you are thinking about a crosstab query...

 

[zfind]

I thought of that, but does that allow data entry also? This item will be used for longer term revenue planning so data needs to be entered.

 

[Pat Hartman]

Data entry should be done in a normalized form. You can either present the data for entry as all the categories for a single period or all the periods for a single category but in any event, the data should be stored as:
Period, category, amount

Use a crosstab to display the data. Crosstabs do not allow data entry because they are aggregations and Jet has no way of identifying a specific row once data has been aggregated.