dynamically change fields in query

[Baz]

I would appreciate any help in the following.

I have an accounting query where i have the following columns

Account_String July, JulyLY, JulyYTD, Aug, AugLY, AugYTD Sep Sep YTD
etc etc

My question is how can i dynamically run a query from this query so i
get the data for the month i request. For example, if i selected
August then i would get the following output only from previous query.

Account_String, Aug, AugLY, AugYTD.

IF you require further info, i have individual tables that i input
Trial Balance data into monthly and i would like to track the
individual account details as listed above.

I would be greatful for any help!!

Baz

 

[Duane Hookom]

Can you normalize your data? Individual tables for months or repeating
fields for months is not good table structure.

 

[Baz]

Hi Duane,

What do you mean by normalizing data? I have 12 seperate tables so i
can add each months trial balance as it becomes available. I created
one big query which will have all the information i require and then i
would like to dynamically run a query from this larger query.

Baz

 

[Duane Hookom]

Storing similar data in 12 different tables doesn't seem normalized to me. A
month value is a data value in most information that I have read. Perhaps
you need to describe your data structure. When months are data values then
they become relatively easy to query.