query by a calculated control

[Guest]

I need to pull records that have "Alert" in one field AND/OR "Red" in
another. They are both calculated. Is there any way around Access not
displaying calculated fields in Queries and Reports. I need to query by these
guys. help

 

[Randy Harris]

I need to pull records that have "Alert" in one field AND/OR "Red" in
another. They are both calculated. Is there any way around Access not
displaying calculated fields in Queries and Reports. I need to query by these
guys. help

Huh? What version of Access doesn't display calculated fields in queries
and reports?

 

[Vincent Johns]

Huh? What version of Access doesn't display calculated fields in queries
and reports?

In Query Design View, for each field, you can set the "Show" property to
either show or hide the field value. In addition, in Query Datasheet
View, you can use Format --> Unhide Columns to select which columns you
want to have visible or not. If either or both properties hide the
field, you won't see it.

But AFAIAA it has nothing to do with whether a field is calculated.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.