Adding Information to a Report

[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!

 

[Duane Hookom]

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?

 

[Mary]

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??)

 

[Duane Hookom]

If there are lots of records with [Cumulative GPA], how do you know which
one record's value to print on the report?