Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2014
    Posts
    25

    Unanswered: Dear All I Need help

    I Need to get Sum then Average for number of pieces for every sales men related to category.

    Kindly look at my DB.
    Dr.Raro
    Attached Files Attached Files

  2. #2
    Join Date
    Sep 2011
    Location
    Australia
    Posts
    264
    Provided Answers: 2
    Hi Dr. Raro
    I my be confused (on medication after operation complications) but I would suggest a restructure of database. A form for salesmen only and a related form for sales would seem appropriate - people and sales are separate entirities. This way you can add new salesmen any time. If each sale record holds saleman id, catagory, amount etc, you can filter, group, etc, these how ever you want.
    David

  3. #3
    Join Date
    Jul 2012
    Location
    Ireland
    Posts
    815
    Provided Answers: 17
    +1 to what David said.
    The way it's structured right now won't work without scripting a ton of unnecessary code.

    Regards
    James

  4. #4
    Join Date
    Sep 2014
    Posts
    25
    Thank you so much dear I will try again.
    Dr.Raro

Tags for this Thread

Posting Permissions

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