Can I create a conditional field name in a query?

[jghumphrey]

SELECT temp.BusName, temp.Jan, temp.Feb, temp.Mar


FROM temp
WHERE temp.[Forms]![frmNoReport]![MoName]=True;

frmNoReport is open, MoName equals Jan, Feb, or Mar but the WHERE does not equate to a field name and asks for input. It then displays all records instead of the 'True' records.

[June7]

No, cannot have conditional field name in a query object.

The month name fields are all Yes/No data type?

This does not appear to be normalized data structure. Can each record have only one month field selected as True? If so, this should be one field with 12 options. If not, should be a related table.

[jghumphrey]

Each record has 12 month fields which can be checked in any combination, all Yes/No.

[June7]

Comments still apply.

A UNION query could rearrange the data to a normalized structure. Then use that query like a table to filter and aggregate data.

[jghumphrey]

I was able to simplify and solve the problem with a multi-valued field. Thanks.

[June7]

I NEVER use multi-value fields but as long as it serves your needs, glad you have a working solution.

[orange]

I was able to simplify and solve the problem with a multi-valued field

That may have got you past some hurdle, but I don't think it's a solution.

Research Normalization and database principles -- your database activity will be more rewarding than it is.
Principles of relational Design http://forums.aspfree.com/attachment...2&d=1201055452
Entity Relationship Diagramming http://www.rogersaccesslibrary.com/T...lationship.zip