Web Development

Ask something
Question Locked

Access report shows duplicate fields

0 helpful
4 replies

by toliver

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have created an Access report from a query. The query shows the information correctly in each of the fields as does the table. The problem is when I create the report - it only shows the information for the first record 4 times. This is probably something simple but to be honest - I am truly stumped!

4 replies

by tink!

Are there only 4 records in your query result? Or did you put the fields on your report 4 times?

by toliver

I have records in the report only one time each. There are a lot more than 4 records - probably about 500. I have tried to run this report several times with the same result. Could it be that I have updated these fields with an update query? That is what is different between the fields that show correctly and those that don't.

by tink!

Update query's purpose is to find and replace things. If you are not telling it to replace anything it may be "confused" and not know what you're asking to be shown.

Admittedly, I have never used an update query but have always manually made my own Select queries for reports. From what I can see, you should be able to easily convert your Update Query. Just open your Update Query in Design mode and under the "Query" menu click "Select Query"

This discussion is closed to new replies.