query by a calculated control

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
CaptDunsull said:
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
Click to expand...

Huh? What version of Access doesn't display calculated fields in queries
and reports?
 
Randy said:
Huh? What version of Access doesn't display calculated fields in queries
and reports?
Click to expand...

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.
 
Back
Top