Adding Information to a Report

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

I'm trying to do the following:

Take a piece of information from one of my tables and
integrate it into a report that has already been
designed. I think the problem has to do with the "Control
Source" section for the properties of this item's box, but
I am honestly not sure how to get this information to show
up when I generate the report. Also, right now when I
click on the Report's open button, I'm getting prompted
for this particular item (cumulative GPA). I do NOT want
to be prompted to enter this...I'm not sure what I'm doing
wrong...please help!
 
If you are being prompted for an item, it means that you have a control
source property set the item in the report or the sorting and grouping. Your
query may also create a prompt.

What do you mean by 'piece of information from one of my tables'? Tables
have fields and records. I assume there is a field named CumulativeGPA or
something similar. Is there only one record in the table? Is there any way
that your table is related to the record source of your report?
 
Thank you so much for your response!

Yes, by "piece of information," I mean a record. And yes,
there is indeed a field named Cumulative GPA that is
entered in every record, not just one. Finally, no, I
don't believe that this record is related to the
information that is on the report...do you think that's
the source of the problem? I guess the bottom line is I
would like this record to show up on this report but
really am not sure how to get it to show up (do I even
need to use the properties box or am I trying in the wrong
place??)
 
If there are lots of records with [Cumulative GPA], how do you know which
one record's value to print on the report?
 
Back
Top