Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Posts
    108
    Provided Answers: 1

    Unanswered: Match Data From Table B Once

    Hi all,

    Using Access 2016.

    How can I match data in Table B to Table A once.
    For example, Table A has 3 occurrences and Table B has 1 occurrence
    B should Match A on the first occurrence only and ignore the other 2

    No matching control numbers unfortunately, just Date, Store and Vendor.

    Thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    use a sub query on the table which has the multiple rows and SELECT TOP or SEELCT DISTINCT in that sub query.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •