Query on Column Heading

V

vjrizzo

I have an Access table containing budget data by month. Each row is an
account, and each column is a month. I'm looking to create a Query that will
return the data for a specified month or a range of months.
 
T

tina

putting data into field names breaks the rules of table normalization.
suggest you correct your table design. such as:

tblAccounts
AcctID (primary key)
AccountName
other fields that describe the account

tblAcctBudgets
AcctID (foreign key from tblAccounts)
BudgetMonth
BudgetYear
BudgetAmount
(primary key can be three fields: AcctID, BudgetMonth, BudgetYear. or you
can add an additional field such as an autonumber, to serve as the primary
key.)

you can query tblAcctBudgets to return any subgroup of data that you need.

hth
 
Top