Why do reports in Access return more info than I want?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shana - 13 Dec 2005 15:49 GMT

I am building a report based on a Query that is built on several related
tables. Some of the fields have a list of choices when data is being entered.
Instead of returning the values in the related tables (which is what is
returned when I run the query), the report is returning the list of choices
for each of the fields. What am I doing wrong?

Reply to this Message

Duane Hookom - 13 Dec 2005 18:54 GMT

Please share your SQL view and let us know which fields are primary and
foreign keys.

Signature

Duane Hookom
MS Access MVP

>I am building a report based on a Query that is built on several related
> tables. Some of the fields have a list of choices when data is being
[quoted text clipped - 3 lines]
> choices
> for each of the fields. What am I doing wrong?

Reply to this Message