Results 1 to 2 of 2
  1. #1
    MSB123 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    2

    Duplicate results

    Hello,

    I have a database that has a table with list of employees and a number of tables with sales by employees and associated payments by month.



    What I'm trying to do is determine the income generated from sales of the subset of employees (read list of employees mentioned in last sentence) in a given period. I can do this for 1 month, but when I try to add multiple months the results seem to duplicate. I can't work out why.

    I think its an easy solution but I'm just missing a basic and can't work it for the life of me.

    Hoping you can help

  2. #2
    MSB123 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    2
    Hi all,

    I'm really sorry I worked it out.
    Thank you though.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Is my duplicate query duplicating results?
    By rebfein in forum Queries
    Replies: 5
    Last Post: 09-11-2017, 12:23 PM
  2. Duplicate data results
    By cdscivic in forum Forms
    Replies: 16
    Last Post: 09-07-2016, 06:43 PM
  3. Replies: 3
    Last Post: 05-01-2013, 09:52 AM
  4. Eliminate Duplicate (mirrored) Results
    By fauowls in forum Access
    Replies: 3
    Last Post: 03-21-2013, 03:39 PM
  5. Suppressing duplicate results
    By jonesy29847 in forum Reports
    Replies: 5
    Last Post: 04-22-2010, 12:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums