How do i create a parameter to display choiced field in a query

[olasule1@yahoo.com]

SELECT m.id, m.surname, m.firstname, m.middlename, Nz([l.aug],0) AS ITEM, Nz([i.aug],0) AS LOAN, m.bank, c.aug AS CONTRIBUTIONS, m.accountno, Nz([l.aug],0)+Nz([i.aug],0)+([c].[aug]) AS Total


FROM ((membershipquery AS m LEFT JOIN loanquery AS l ON m.id = l.membershipid) LEFT JOIN itemquery AS i ON m.id = i.membershipid) LEFT JOIN membercontributionsquery AS c ON m.id = c.membershipid;

I created a database using Access 2010,I am thereby looking for a way to create a parameter for the user to be able to display the month needed without having need to come to sql or design view to do it. I look Forward to your response please.

Sulaiman Lukman.

[June7]

Fields in query object design cannot be dynamic. Filter parameter can be dynamic.

It appears your data structure is not normalized. Do you have a field for each month?

[olasule1@yahoo.com]

Fields in query object design cannot be dynamic. Filter parameter can be dynamic.

It appears your data structure is not normalized. Do you have a field for each month?

"I think it is normalized I tried to follow the rules, Yes I have a field for each month."

[June7]

A field for each month is not normalized structure. This will likely give you lots of issues, as you have just encountered.

Normalized would be a field with month (or full date) values and a field for the data currently saved in separate month fields. So 2 fields instead of 12.

[olasule1@yahoo.com]

Hi
Thank you,but I tried to fine tone (Normalized) and realized my situation is a bit different in that very month has its peculiar deductions on item collected,loan collected and monthly contributions into the society. And all has actually been working fine but I dont know further advice you may give.

LS

[June7]

Doesn't matter what the monthly requirements are, a normalized database should still handle the data.

IMO, it is a balancing act between normalization and ease of data entry/output.

Doesn't change the fact that fields in query object design cannot be dynamic.