dynamically change fields in query

  • Thread starter Thread starter Baz
  • Start date Start date
B

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
 
Can you normalize your data? Individual tables for months or repeating
fields for months is not good table structure.
 
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
 
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.
 
Back
Top