INSERTING A FIELD INTO A REPORT

  • Thread starter Thread starter CINDY K
  • Start date Start date
C

CINDY K

I have a report based on a query that is based on several
tables. There is also an expression on the query to limit
what shows up on the report. The properties on the report
start with "Select Distinctrow"...

Now I need to add a couple of fields. (I have many
reports to do this to, that is why I am resistant to re-
create)

I have added the fields to the tables, added them to my
forms, and added them to the query. But how do I get them
to show up in that drop down for fields on the report so
that I can drag them into place?
 
Cindy.
If the report's record source start with "Select .. etc." then a query is
not the report's record source. That SQL is.
Click on the Report's RecordSource property line.
Click on the button with the 3 dots that will appear on that line.
When the QBE grid appears, add the new fields to the grid.
Save the changes.
Now you should be able to add the fields from the Field List tool button.
 
Back
Top