Results 1 to 2 of 2

Thread: comparing lists

  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Unanswered: comparing lists

    Hi

    am pretty new to database work and looking to compare to lists. one being accomodation and the other a payroll. i want to be able to compare the 2 lists and if people are no longer on the payroll, delete them from accomodation. equally if there is a new name on the payroll I would like to add them to accomodation.

    is access the app to use? or is there an easier way to do this?

    cheers

    3xQuid

  2. #2
    Join Date
    Sep 2003
    Location
    T.O.
    Posts
    326
    Use the Find Unmatched Query Wizard to create two queries.
    All code ADO/ADOX unless otherwise specified.
    Mike.

Posting Permissions

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