Microsoft Access Using Aggregate Functions Group By Queries

[merciless41582]

Hey guys I need help I'm trying to Sum all my prices to a total but the sum isn't an option is none and count help me please

[pimpmymail]

but the problem is how can i let the Australians alone with their average profit and the same thing for Brazilians???????

[pimpmymail]

the question says A stands for customers from Australia and B stands for customers from Brazil

in the customer ID i have information like : A0920, A0357, B2992, B2929, A1842 ...

Now in the table there is a Sales and Purchase price for the cars of the customers

The question wants me to show the Average profit per sale FOR EACH CATEGORY ( Australians and Brazilians )

Step 1 : Build in the query a profit equation

I know about the TOTAL button that gives you the Grouping "Group By"

[pimpmymail]

Ok so if you have a table with the following information about the customers : their ID starts with A or B

[laffintunes]

Probably not enough space to display it, widen the column.

[ChezD83]

Can u help?? when i follow this for a grouped query, i get a few of the totals but the rest just looks like this -> ############ what am i doing wrong?? any help please??