adding a cell to a report?

R

Robert Blackwell

There's a report that I want to add a field to the fiels is the prefix of
the isbn. Currently it's only showing ISBN_B. This cell is in our inventory
table, in that table is also ISBN_A. However, if I duplicate the text box of
ISBN_B and then right click for properties, ISBN_A doesn't appear in the
control source drop down as a cell I can use. How can I add this cell from
the inventory table to that list so I can add that field ot the report?
 
A

Arvin Meyer

Robert Blackwell said:
There's a report that I want to add a field to the fiels is the prefix of
the isbn. Currently it's only showing ISBN_B. This cell is in our inventory
table, in that table is also ISBN_A. However, if I duplicate the text box of
ISBN_B and then right click for properties, ISBN_A doesn't appear in the
control source drop down as a cell I can use. How can I add this cell from
the inventory table to that list so I can add that field ot the report?
Click to expand...

There is probably a query used as a recordsource for the report. Make sure
the field from the table is in the query. Then it will show up in the field
list.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
R

Robert Blackwell

Is it possible to find out which query the report is using (maybe by
rightclick> properties to something)? I just tried lookin at a couple of
queries that I thought it would have used but I didn't see the cell ISBN_B
in either of them.
 
D

Douglas J. Steele

Open the report in Design mode and look at its properties. Record Source
(which is what you're looking for) should be the first property on the All
tab of the Report.
 
R

Robert Blackwell

Okay thanks. I see it doesn't use a query but just an sql statement. I was
able to add tblInventory.ISBN_A, and everythign worked just fine.

Thanks for the help.
 
Top