Categories
Microsoft Access

How to Find Duplicate Records in Access

Follow the steps below to learn how to find duplicate records in your MS Access database:

  1. Click the Create tab.
  2. Click Query Wizard.
  3. Click Find Duplicates Query Wizard.
  4. Click OK.
  5. Click the table in which you want to find duplicate information.
  6. Click Next.
  7. Click the field that might contain duplicate information.
  8. Click Add.
  9. Repeate steps 7 and 8 to add any other fields you wish to the query.
  10. Click Next.
  11. Click any other field to display in the query results.
  12. Click Add.
  13. Repeat steps 11 and 12 as necessary.
  14. Click Next.
  15. Key in a name for the query.
  16. Click Finish.

There you have it!

Categories
Microsoft Access

Make Access Reports More Readable with Numbering

There is a simple way to improve your MS Access report design and that is by numbering each item.

Long reports are easier to reference by sequentially numbering the line items.

Follow the steps below to learn how:

  1. Open your report in Design View.
  2. Place a text box named txtRunningSum at the left side of the detail section of the report.
  3. Click in the Control Source Property and enter =1.
  4. Click in the Visible property and select No.
  5. Click in the Running Sum property and select Over All.
  6. Add another text box next to txtRunningSum.
  7. Enter this code in the Control Source property:

=[txtRunningSum]&”.”

It is always easier once you know how isn’t it?