Query field won't display in report

  • Thread starter Thread starter cbart
  • Start date Start date
C

cbart

I'm sure this will be an easy one for someone. I have a query that has a
field that sums up a grand total. I want that grand total field to display
in my report. I can't get it to work with the control source option. I've
tried a lot of things, but I keep getting syntax errors that mean nothing to
me. Using Access 2003 and I'm trying to add the field to an existing report.
Any ideas? Thanks much!
 
I'm sure this will be an easy one for someone. I have a query that has a
field that sums up a grand total. I want that grand total field to display
in my report. I can't get it to work with the control source option. I've
tried a lot of things, but I keep getting syntax errors that mean nothing to
me. Using Access 2003 and I'm trying to add the field to an existing report.
Any ideas? Thanks much!
Click to expand...

Is the query the record source for the report?
If so, then the grand total field should be in the Field List tool
button. Just drag it onto the report.

If the query is NOT the record source for the report, you can use, as
the control source of an Unbound text control:
=DLookUp("[GrandTotalFieldName]","QueryName")
 
Thanks fredg! It wasn't on the list so I used the expression you suggested.

fredg said:
I'm sure this will be an easy one for someone. I have a query that has a
field that sums up a grand total. I want that grand total field to display
in my report. I can't get it to work with the control source option. I've
tried a lot of things, but I keep getting syntax errors that mean nothing to
me. Using Access 2003 and I'm trying to add the field to an existing report.
Any ideas? Thanks much!
Click to expand...

Is the query the record source for the report?
If so, then the grand total field should be in the Field List tool
button. Just drag it onto the report.

If the query is NOT the record source for the report, you can use, as
the control source of an Unbound text control:
=DLookUp("[GrandTotalFieldName]","QueryName")
Click to expand...
 
Back
Top