Calculated field in reports

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

Guest

I am using a database in Microsoft Access 2002 that includes a table for
"Proposals". (2 of the fields in the proposals table are "today's date" and
"due date") I created a query that calculates the number of days pending
since the proposal has been sent out, which is calculated based on whatever
today's date is and the due date of the proposal. This calculation seems to
work fine in the query, however, when I try to run a report, it does not. If
I try to generate a report based on this query for "Days Pending", it asks
for a parameter value for "=exp2". I'm completely lost! I want to be able
to run a report and have the number of days pending show up on the report
calculated. Is this possible??
 
Is it possible that you created a calculated column in your query with an
Alias of exp2 and later renamed the column to Days Pending? If so, you might
have created your report using the column exp2 and possibly used the
column/field in your sorting and grouping.
 
BDAssist said:
I am using a database in Microsoft Access 2002 that includes a table for
"Proposals". (2 of the fields in the proposals table are "today's date"
and
"due date") I created a query that calculates the number of days pending
since the proposal has been sent out, which is calculated based on
whatever
today's date is and the due date of the proposal. This calculation seems
to
work fine in the query, however, when I try to run a report, it does not.
If
I try to generate a report based on this query for "Days Pending", it asks
for a parameter value for "=exp2". I'm completely lost! I want to be
able
to run a report and have the number of days pending show up on the report
calculated. Is this possible??
Click to expand...

If the field is calculated in the query on which the report is based, then
make
the data source of the control on the report just be the name of the
calculated
field just as if it were any other query field.

Tom Lake
 
Back
Top