Gross margin percentage calculation by customer

[tmwardga]

**********

[alansidman]

Homework
Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).


We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.


If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.

[tmwardga]

Ok, well I certainly did not mean for my request to be interpreted that way. I am searching for help, not the answers. I am frustrated because I cannot seem to grasp an understanding of the material. My instructor is very hard to understand. I will refrain from posting any further material or questions. Thank you for the warm welcome.

[pbaldy]

I saw the original post yesterday and while I wasn't in a position to answer at the time, it did seem like you had put in some effort to solve the problem. It appeared there was a table for sales and another for costs? Look at totals queries, the big "E" on the ribbon with a query in design view. You want to Group By customer and Sum sales/costs (if appropriate, the date and type fields with criteria would have Where.

I thought the criteria on your date fields was very odd. Are they actually date/time fields, or text (they should be date/time)?

[pbaldy]

Oh, and I don't think it was being suggested that you don't post questions. You're encouraged to do so; that's what we're here for!