Column And Queries

[D. Austin]

Dear MVP’s

I have a Budget table that has 12 columns containing cumulative budget
amounts for each month. I need to compare the budget with actual each month.
Is there an expression I can create to change what column I pull the data
from?

For example currently I have this

[BUDGET]![MONTH 1] but I want this [BUDGET]![MONTH 2] . I do not want my
user to have to edit the query I just want them to change the month from a
form and run the report.


Thanks for your help.

D

 

[Duane Hookom]

The month should be a data value in a column, not a field name. A properly
normalized table would allow users to enter a month.

We don't know how/where you are storing actual.

 

[D. Austin]

That's what I was afraid you were going to say. I guess I will to some
converting of the table.

Thanks for your help.

The month should be a data value in a column, not a field name. A properly
normalized table would allow users to enter a month.

We don't know how/where you are storing actual.

--
Duane Hookom
MS Access MVP

Dear MVP's

I have a Budget table that has 12 columns containing cumulative budget
amounts for each month. I need to compare the budget with actual each
month.
Is there an expression I can create to change what column I pull the data
from?

For example currently I have this

[BUDGET]![MONTH 1] but I want this [BUDGET]![MONTH 2] . I do not want my
user to have to edit the query I just want them to change the month from a
form and run the report.


Thanks for your help.

D