Hello,
I have a question on trying to run a query. So I have a report that has all my information and I ran a query to pull up all duplicates. I created another query to add up those duplicates. Now I want to to bring those duplicate totals back to my original spreadsheet. Ive been stuck with a trying to run a query. The below query does not bring any results. Is there another way to bring in my numbers?
SELECT [HRIS Tax Benefits Report].[Points Left]
FROM [HRIS Tax Benefits Report] INNER JOIN [Sum of Duplicate Numbers] ON [HRIS Tax Benefits Report].[User Login ID] = [Sum of Duplicate Numbers].[User Login ID]
WHERE ((([HRIS Tax Benefits Report].[Points Left])=IIf([Sum of Duplicate Numbers]![User Login ID]=[HRIS Tax benefit Report]![User Login ID],[Sum of Duplicate Numbers]![Sum Of Total Point Value],0)));
I have a question on trying to run a query. So I have a report that has all my information and I ran a query to pull up all duplicates. I created another query to add up those duplicates. Now I want to to bring those duplicate totals back to my original spreadsheet. Ive been stuck with a trying to run a query. The below query does not bring any results. Is there another way to bring in my numbers?
SELECT [HRIS Tax Benefits Report].[Points Left]
FROM [HRIS Tax Benefits Report] INNER JOIN [Sum of Duplicate Numbers] ON [HRIS Tax Benefits Report].[User Login ID] = [Sum of Duplicate Numbers].[User Login ID]
WHERE ((([HRIS Tax Benefits Report].[Points Left])=IIf([Sum of Duplicate Numbers]![User Login ID]=[HRIS Tax benefit Report]![User Login ID],[Sum of Duplicate Numbers]![Sum Of Total Point Value],0)));
