RE: Problem with IIf statements in Query Criteria (Access 2007)

[lomiA]

I have a problem with setting up IIf statement in Query criteria:



I have an Access 2007 database and I am trying to retrieve a list of addresses depending on the letter "X" in the month fields. Each address has the letter X in either all the months or quarterly.

The following is the list of fields in my table:
ID Address Jan Feb Mar Apr Jun Jul Aug Sep Oct Nov Dec

Also, I have a form(FR_Search) with combo box(month) to select the month and run a query to retrieve the addresses with "X" under the selected month.

So, I created a query and under month field for e.g Jan field, I entered: IIf([forms]![FR_Search]![month]="JAN","X","") and this works for January only, but when I added similar IIf statements to other months, the query for January no longer works.

I am very new to Access. if anyone could help out, I would appreciate it very much. If you have any alternative solutions that would be great as well.

Thank you.
Lomi

[June7]

This data structure is not normalized and will cause you all kinds of frustration, this is only the first.

Each criteria must be on a separate criteria row to invoke the OR operator.

[lomiA]

This data structure is not normalized and will cause you all kinds of frustration, this is only the first.

Each criteria must be on a separate criteria row to invoke the OR operator.

Thank you for your reply. But, how do you normalized the data structure that I have right now?

[LaughingBull]

watch this video https://www.youtube.com/watch?v=NuzCeyQOSzg