Getting a Number from a Form to a Report

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I created a database using access97. I am trying to write
a report to show a number that appears on the form.
Everytime I try to use this particular number it shows the
ID pointing to the number instead of the actual number.
If I go in and look at the report using datasheet view it
shows the correct number, however I can never get it to
point to the actual number instead the ID or index of that
particular number keeps showing. How can I get the actual
number that shows on the form to show in my report rather
than the ID index? Thanks.
 
Mark said:
I created a database using access97. I am trying to write
a report to show a number that appears on the form.
Everytime I try to use this particular number it shows the
ID pointing to the number instead of the actual number.
If I go in and look at the report using datasheet view it
shows the correct number, however I can never get it to
point to the actual number instead the ID or index of that
particular number keeps showing. How can I get the actual
number that shows on the form to show in my report rather
than the ID index? Thanks.
Click to expand...


Sounds like your table has one of those, to be polite,
befuddling Look Up fields.

If so, then you need to add the look up table into the
report's record source query so you can add the number field
instead of the ID field.
 
Back
Top