Access Report displays the wrong info

H

Herman

I created a report that is based on a query. The query
searches the table "redodata" for all records where the
field "fault" is not equal to various values.

When I open the query, everything looks OK. However when
I created the report based on the Query, it finds
everything OK, but for SOME groups, it displays the value
of the Primary Key rather than the actual value.

What did I do wrong? It only happens with some of the
records. I know it is the value of the Primary Key
because it returned the number "8", which is the Primary
Key value for "MO-FR". It should have returned the
value "MO-FR".

HELP!
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Controlling printed records when report bound to multiple tables 0
Display all records from table regardless of relationship 6
Report based on Query 1
DLookkup returns error 2
Access 2010 DB not fuctional with multiple users 2
Using a query parameter for a report 4
Summing Field in Report 1

Top