Question

Locked

Access report shows duplicate fields

By toliver ·
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!

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

4 times?

by Tink! In reply to Access report shows dupli ...

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

Collapse -

Ya - that's what I thought too...

by toliver In reply to 4 times?

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.

Collapse -

That could be

by Tink! In reply to Ya - that's what I though ...

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"

Collapse -

There might be something in that same google book..

by Darryl~ Moderator In reply to Access report shows dupli ...

That section starts on page 297.....the following link should take you there....I didn't look through it though.

http://books.google.ca/books?id=0vaEcTMIOKgC&pg=PA297&lpg=PA297&dq=access+2007+report+only+produces+the+first+record&source=bl&ots=BBbTxQVMFj&sig=-JIJryDuibUU2-M98TjG0fMMvss&hl=en&ei=NncGTMqaGoH-8AaciemTCw&sa=X&oi=book_result&ct=result&resnum=6&ved=0CCcQ6AEwBTgK#v=onepage&q&f=false

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums