Search results

  1. S

    Appending the most recent record

    Hi all In an append query with employee records that may have different information, I would like to only append to a new table the most recent record when multiple records exit for the same employee. With a primary Key in Employee Id how can I do this? The employees location, title, manager...
  2. S

    Append Query - without sort

    Hello, In an append query with a Key field I find that the records seem to be automatically sorted on the Key field. They get inserted in between the records. I would like the new records to be appended to the bottom of the table. I have tried to look into the table sort orders but couldn't...
  3. S

    Totals Query - Return accounts that generate 80% of sales

    Hello, I am trying to do a Totals query that would return accounts that produce 80% of the total revenue. I hope to sort the sum of revenues from each account in descending order then select these top accounts whose revenue sum is 80% of the total sales. The idea is to find out which and how...
  4. S

    Only display query results if records found

    Dear Experts In access macro I would like to display the results of an OpenQuery only if the query returns records. I don’t want to open empty query result sheets. I know that DCount() returns the number of the records in a query but I am not sure how to use it without actually opening an IF...
  5. S

    Joining queries created with QueryDef

    Hi All, I need a way to create successive select queries and join the next query with the previous one in VBA using QueryDef. Example Query Level 0: RevenueRollup_sub_0 SELECT SalesRevenues.EmployeeName, SalesRevenues.SalesRevenue AS TotalRevenue, SalesRevenues.ManagerName FROM...
  6. S

    VBA Procedure for Sales Revenue Roll for up to 5 levels

    Dear VBA Gurus, I have sales revenue data that I need to frequently analyze and roll up to the next level manager from all his reports. The sales achievement of a manager is the sum of the achievements of his direct reports. I have a 5 level employee hierarchy with level 0 being the field...
  7. S

    Revenue Rollup to the next level manager - recursive queries

    Hello, I have sales revenue data that I want to roll up to the next level manager from all his reports. The achievement of a manager is the sum of the achievements of his direct reports. I have a 5 level employee hierarchy with level 0 being the field sales people and levels 1 to 5 are the...
Back
Top Bottom