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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Please share your SQL view and let us know which fields are primary and
foreign keys.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report based on Query 1
Return the Most Recent Update 4
Can't create a report from my query in Access 1
Memo field truncating in report 3
Access Access Report Works on One Machine but not Another 3
Carriage Returns in an Access report. 1
The specified Field Could refer to more than one table... Access 2 5
Missing data in Access reports 6

Back
Top