I am looking for help with an Access database. I have a table With multiple fields, but I only need a few to create a report. The fields I have to use are Log In Date, Log Out Date Actual Dollar Amount, and Agent.Hi. Welcome to AWF!
Through two queries, I have created a Log In Monthly Count query which has isolated the Count of Log In Date, combined with a Month listing (the table has numerical dates and I need alpha months) and year. Here is the code.
SELECT [Log In Count].PA, [Log In Count].[CountOfLog In], [Month Listing].Month, [Log In Count].[Log In Year]
FROM [Month Listing] INNER JOIN [Log In Count] ON [Month Listing].ID = [Log In Count].[Log In Month];
I have done the same with a Log Out Totals query.
SELECT [Log Out Count].PA, [Log Out Count].[CountOfLog Out], [Log Out Count].[SumOfActual Dollar Amt], [Month Listing].Month, [Log Out Count].[Log out Year]
FROM [Month Listing] INNER JOIN [Log Out Count] ON [Month Listing].ID = [Log Out Count].[Log Out Month];
Both of these work great individually, but when I combine them, I get multiple lines for each month. For example, one agent has a log in count for 5 months, so the query duplicates those 5 log in counts for each of the Count of Log Out Dates. This occurs in the report as well. Here is the coding for my combining query.
SELECT [Log In Monthly Count].PA, [Log In Monthly Count].[CountOfLog In], [Log Out Totals].[CountOfLog Out], [Log Out Totals].[SumOfActual Dollar Amt], [Log Out Totals].Month, [Log Out Totals].[Log out Year]
FROM [Log In Monthly Count] INNER JOIN [Log Out Totals] ON [Log In Monthly Count].PA = [Log Out Totals].PA;
Any ideas how to get rid of the duplicates? My report is grouped by Month, and sorted by agent (PA)