Temporarily denormalize a table

[Paul77fox]

Hello everyone! I need some help here!
The main table structure is : client_id : month_id : service_id : amount :

I would like to have a form with client_id like combo box, and then temporarily denormalize the rest of the table (month_id, service_id, amount) to look like a spreedsheet (month_id for rows, service_id for columns and amount for cell content) for viewing and printing purposes only. I assume that will be a lot to program and I'm not very glad because of that, as a very new user of Ms Access 2010.
Could anyone help me? Thank you!

 

[MajP]

http://office.microsoft.com/en-us/a...ad-by-using-a-crosstab-query-HA010229577.aspx

 

[SkipVought]

hi,

What you seem to mean is not to "Temporarily denormalize a table," but to REPORT the data from table(s) in such a way that you would not store the data, which actually occurs any time you do any kind of aggregation (sum, count, average, min max, etc) query.


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]