Question

  • Creator
    Topic
  • #2211692

    Access report shows duplicate fields

    Locked

    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!

All Answers

  • Author
    Replies
    • #3026155

      Clarifications

      by toliver ·

      In reply to Access report shows duplicate fields

      Clarifications

    • #3026150

      4 times?

      by tink! ·

      In reply to Access report shows duplicate fields

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

      • #3026149

        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.

        • #3026139

          That could be

          by tink! ·

          In reply to Ya – that’s what I thought too…

          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”

Viewing 1 reply thread