Three Problems I’m having with combining Query

[TJVFree]

I’m working on compiling three queries into on

The first one counts the number of apps
The next one sums the told worth of apps
And the last one ranks the reps by apps

Three Problems I’m having:

**When running the query is takes 20 -30 minutes. (I’m assuming this is do to the Ranking field)
**I’m not able to get the mail table to index (gives me a error about duplicates)
**I compact and repair a couple times throughout the day

**When running the query it starts to show duplicates.
**When I run the query by themselves they show the correct number of records
**The output information for my Ranking data has to many numbers after the .list=1]It looks like this 4.57842136
**I would like it to look like this: 4.6

SELECT [Master Table_Total_per_Month].OMNI_Number, [Master Table_Total_per_Month].Account_Executive_Name, [Master Table_Total_per_Month].[Correspondent Name], [Master Table_Count_Apps].[Total Of AMOUNT_ACTUAL_LOAN] AS Total_LoanYTD, [Master Table_Total_per_Month].[Total Of AMOUNT_ACTUAL_LOAN] AS Total_Loan_AmountTYD, [Master Table_Count_Apps].Jan AS Jan_App_Count, [Master Table_Total_per_Month].Jan AS Jan_Loan_Amount, [Master Table_Count_Apps].Feb AS Feb_App_Count, [Master Table_Total_per_Month].Feb AS Feb_Loan_Amount, [Master Table_Count_Apps].Mar AS Mar_App_couont, [Master Table_Total_per_Month].Mar AS Mar_Loan_Amount, [Master Table_Count_Apps].Apr AS April_App_Count, [Master Table_Count_Apps].Apr AS April_Loan_Amount, [Master Table_Count_Apps].May AS May_App_Count, [Master Table_Total_per_Month].May AS May_Loan_Amount, [Master Table_Count_Apps].Jun AS June_App_Count, [Master Table_Total_per_Month].Jun AS June_Loan_Amount, [Master Table_Count_Apps].Jul AS July_App_Count, [Master Table_Total_per_Month].Jul AS July_Loan_Amount, [Master Table_Count_Apps].Aug AS Aug_App_Count, [Master Table_Total_per_Month].Aug AS Aug_Loan_amount, [Master Table_Count_Apps].Oct AS Oct_App_Count, [Master Table_Total_per_Month].Oct AS Oct_Loan_Amount, [Master Table_Count_Apps].Nov AS Nov_App_count, [Master Table_Total_per_Month].Nov AS Nov_Loan_Amount, [Master Table_Count_Apps].Dec AS Dec_App_Count, [Master Table_Total_per_Month].Dec AS Dec_Loan_Amount, [Master Table_Total_per_Month].[3Month], [Master Table_Total_per_Month].[6Month], [Master Table_Total_per_Month].[9Month], [Master Table_Total_per_Month].[12Month], [Master Table_Total_per_Month].CustomerTotal, Master_Table_Rank.Rank, Master_Table_Rank.TotalRecords, Master_Table_Rank.[0to5Rank]
FROM ([Master Table_Total_per_Month] LEFT JOIN [Master Table_Count_Apps] ON [Master Table_Total_per_Month].OMNI_Number = [Master Table_Count_Apps].OMNI_Number) LEFT JOIN Master_Table_Rank ON [Master Table_Count_Apps].OMNI_Number = Master_Table_Rank.OMNI_Number
GROUP BY [Master Table_Total_per_Month].OMNI_Number, [Master Table_Total_per_Month].Account_Executive_Name, [Master Table_Total_per_Month].[Correspondent Name], [Master Table_Count_Apps].[Total Of AMOUNT_ACTUAL_LOAN], [Master Table_Total_per_Month].[Total Of AMOUNT_ACTUAL_LOAN], [Master Table_Count_Apps].Jan, [Master Table_Total_per_Month].Jan, [Master Table_Count_Apps].Feb, [Master Table_Total_per_Month].Feb, [Master Table_Count_Apps].Mar, [Master Table_Total_per_Month].Mar, [Master Table_Count_Apps].Apr, [Master Table_Count_Apps].Apr, [Master Table_Count_Apps].May, [Master Table_Total_per_Month].May, [Master Table_Count_Apps].Jun, [Master Table_Total_per_Month].Jun, [Master Table_Count_Apps].Jul, [Master Table_Total_per_Month].Jul, [Master Table_Count_Apps].Aug, [Master Table_Total_per_Month].Aug, [Master Table_Count_Apps].Oct, [Master Table_Total_per_Month].Oct, [Master Table_Count_Apps].Nov, [Master Table_Total_per_Month].Nov, [Master Table_Count_Apps].Dec, [Master Table_Total_per_Month].Dec, [Master Table_Total_per_Month].[3Month], [Master Table_Total_per_Month].[6Month], [Master Table_Total_per_Month].[9Month], [Master Table_Total_per_Month].[12Month], [Master Table_Total_per_Month].CustomerTotal, Master_Table_Rank.Rank, Master_Table_Rank.TotalRecords, Master_Table_Rank.[0to5Rank];