Adding New Fields To A Report

  • Thread starter Thread starter Phillip
  • Start date Start date
P

Phillip

I have a report that I would like to add new fields to.
The new fields are in a query (the report is the result of
several queries).

I can't figure out how to add new fields. The field list
box only shows fields from the queries my report is based
on.

Does anyone know how to do this?

Thanks
..
 
I have a report that I would like to add new fields to.
The new fields are in a query (the report is the result of
several queries).

I can't figure out how to add new fields. The field list
box only shows fields from the queries my report is based
on.

Does anyone know how to do this?

ummmm... change the query your report is based on, I'd suggest. It
can't display fields from queries that it doesn't know about!

You could use DLookUp() to look up the values from the query, but it
would be very inefficient.
 
Back
Top