Query on Column Heading

[Guest]

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.

 

[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