Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2009
    Posts
    1

    Unanswered: Tracking Fleet Expenses

    I need to track expenses for our leased cars. It's tricky because a car can be leased at one of our branches for either a salesman or branch manager.

    For example:
    Branch 1 Salesman's car coded to 5300; Br Manager's car coded to 7300

    Cars can be moved between branches and Salesman or Br manager employees.

    How can I track the expenses of a car originally leased at Branch 1 for a Salesman Jan - Mar, 2009 and then transferred to Branch 2 to the Br Manager? Branch 1 then gets a new leased car for their Salesman Apr - Dec, 2009.

    How can I get the total 2009 Salesman expenses for Branch 1?

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    ? with not even a hint as to your table structure, how can anyone know?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •