Variable name for a query arguement

[Guest]

Hello,

I am working on a database system that combines financial data within one
consolidated report on a monthly trend basis. The thing that I am having
trouble with is bringing all the information together for the report. I need
to show the following information depending on what the month is: Actuals,
Forecast, Outlook, Plan or HGL. each month has an amount for it for example
november would have the following amounts located in 2 different tables:
NovAct, NovFcst,NovOut, NovPlan, NovHGL.

What I am trying to do is create a query argument that would be variable so
if the user has selected Act for Nov-Aug and Fcst for the rest of the months
is there any way to set up an argument so that it would take the month "Nov"
and add the type (Located in a monthly definition table) together and pick
this variable amount up from the table\query that is assigned within the
query.

Hopefully I have made myself clear, if you require any further information
please feel free to contact me.

Any help would be greatly appreciated.

Thanks

 

[JohnFol]

I think you need to expand on the table design as it looks like your field
names inclide the month prefix.