Results 1 to 4 of 4
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Please Help (Access 2000)

    Welcome to Woody's Lounge!

    Have you considered using Excel? That may be easier to use for this kind of problem than Access.

    If you prefer Access, you'd have to create a record for each representative for each date in advance, which is not very efficient.

  2. #2
    New Lounger
    Join Date
    Aug 2005
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Collect data for multiple dates (Access 2000)

    Subject edited by HansV to aid in future searches. "Please Help" was not very informative.

    Hi,

    Hope someone can help I have been trying to get a database working for ages and its getting to the stage where I need to get it out and I

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Collect data for multiple dates (Access 2000)

    If you truly want to use Access, just put each call for each sales rep for each date into a table and then use a totals query to total the calls for each person.
    Charlotte

  4. #4
    New Lounger
    Join Date
    Aug 2005
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Collect data for multiple dates (Access 2000)

    Thanks for your help !
    Looks like excel is the way to go with this.

    Thanks,
    Staines

Posting Permissions

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