I am running a query and keep getting duplicate results which are always mirrored. Example:
Jim New York 4 5 Miami Mandy Mandy Miami 5 4 New York Jim
Is there any way to avoid this from happening?
I am running a query and keep getting duplicate results which are always mirrored. Example:
Jim New York 4 5 Miami Mandy Mandy Miami 5 4 New York Jim
Is there any way to avoid this from happening?
Post the query SQL statement.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
SELECT SBT.SBT, ARQ_SBT_DB.Application, ARQ_to_Right.Right, ARQ_to_Right_1.Right, ARQ_SBT_DB.Application2, SBT_1.SBT
FROM(((ARQ_SBT_DB INNER JOIN ARQ_to_Right ON ARQ_SBT_DB.[Action Name] = ARQ_to Right.Action) INNER JOIN Right AS ARQ_to_Right_1 ON
ARQ_SBT_DB.[Action Name2] = ARQ_to_Right_1.Action) INNER JOIN SBT AS SBT_1 on ARQ_SBT_DB.SBT_2 = SBT_1.Nr)INNER JOIN SBT ON ARQ SBT_DB.SBT = SBT.Nr
GROUP BY SBT.SBT, ARQ_SBT_DB.Application, ARQ_to_Right.Right, ARQ_to_Right_1.Right, ARQ_SBT_DB.Application2, SBT_1.SBT;
I see 4 tables/queries involved:
SBT
ARQ_SBT_DB
ARQ_to_Right
Right
Think I am going to need source tables and all queries to analyse this. If you want to provide db follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.