Use a field in an expression but not show

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

Guest

I have a field in a query I want to use in a calculation. The results of the calculation are shown on a report with a bar graph chart. The problem I am having is when I select "show" in my query my calculation works fine but the field shows up on my graph. If I do not select "show" I am prompted for the value of the field. How can I use the field without it displaying on the report?


Thanks!

-Tim
 
Tim;

Usually a calculation expression is something like this
Result: [Amount]+[Markup] ' A colon after the expressions name: Resut:

If Your qry is based on a Table change the expression to:
Result [tblMain]![Amount]+[tblMain]![Markup] ' Where [tblMain] is the
name of the Table containing the Amount and Markup fields.
' Displayed in the area above the Field Columns.

If Your qry is based on a Query change the expression to:
Result [qryMain]![Amount]+[qryMain]![Markup] ' Where [qryMain] is the
name of the Query containing the Amount and Markup fields.
' Displayed in the area above the Field Columns.

Then You can remove both Amount and Markup fields from the active Query.
Don't need 'em in the Qry for the calculation, don't need in tto display or
hide 'em..

Andy


Tim said:
I have a field in a query I want to use in a calculation. The results of
Click to expand...
the calculation are shown on a report with a bar graph chart. The problem I
am having is when I select "show" in my query my calculation works fine but
the field shows up on my graph. If I do not select "show" I am prompted for
the value of the field. How can I use the field without it displaying on the
report?
 
Back
Top