Search results

  1. D

    Show Null values from Union query

    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...
  2. D

    Question Automating Access Tables & Exporting Data to Excel

    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...
  3. D

    Select Query producing inaccurate results

    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...
  4. D

    Query to a

    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...
Back
Top Bottom