Recent content by dubez

sure, it is pretty long, so I have posted just 4 Unions but the remaining 12 queries follow the exact same logic with the exception of the "BD_Code". Here it is: SELECT TOP 10 Top_10_RSP_Loans_Advisor_A.BD_Code, Top_10_RSP_Loans_Advisor_A.[Dealer-Rep_Code]...

Hi friends, I have a Union query that extracts the top 10 sales reps by each province. The problem is when the province does not have 10 sales reps that had business, it will not show 10 records. This seems fairly simple but I am not sure if I should be changing my union query or the table...

Thanks Spikepl! I do use and understand queries so i am able to do this and currently do for my manual process. Would you recommend i build out all the queries for each of the Programs first or is there a way this could be done in the bigger macro to bypass the manual process of creating all...

Hi there! I have the following following raw data in an access table (Raw_Data): Raw_Data Table: Program Dealer Agent Product (either Product A or Product B) Date Funded Funded Amount ($) Now, i have an Excel template I need updated (one template/spreadsheet would need to be updated per...

I actually removed the "Distinct" Clause in the SQL statement and it looks like it now works. Thanks for the help!

Well I am matching the dates up to what I have in the back end and it does not match. All other fields appear to be showing accurate results, however the "Date Completed" field is wonky and it is not matching up to the "ADI_DISTRIBUTOR_ADVISOR" number. Should I be doing this in another way or...

Hi, I have a query that is returning inaccurate "Date Completed" results, please help! Here is the SQL: PARAMETERS [Enter Start Date] Text ( 255 ), [Enter End Date] Text ( 255 ); SELECT DISTINCT [Qry BDM FA English Email Test Part 1].ADI_DISTRIBUTOR_ADVISOR...

Re: Query to avoid using certain date fields Ok, I dont know if im doing a good job explaining this so Ill show the tables and queries Im using. Table 1: Date Name Email ID 9/12/2012 Joe Blow Blank 3024-2n9k 9/13/2012 John Smith Blank 3077-1556 9/14/2012 Jane Doe Blank...

So, if we assume Table A is where I would store all my ID/Email Data for Week 1 and Table B is my Final Email list to be sent out, what would my next steps be? In Week 1 when the email list is sent I will have nothing to matchup the records against. However, in Week 2,3,4, etc. will I will...

Thanks Paul, that really helps! Can you please elaborate on this process though? Would I need to make a query and use an IF statement to gather only the valid records in week 2?

Hi there! I have received much help here in the past and was hoping I could get an answer to this problem I'm having. I have records using a select query that I am sending to a make table. I would like to have those records excluded from being used again for 180 days, at which point they can...