Assignment+3

So I tried starting Assignment 3 and I'm kind of struggling with it. I was fine when I did the in class assignments, but I guess I'm still not that comfortable with Access. It probably didn't help that the computer I was on had Access 2007, whereas we used the 2003 version in class. Is anyone else having problems? Any suggestions would be appreciated. I'm thinking about going to the business library after class tomorrow (on Wed, Aug 4) and working on it so feel free to come join me!

I think I understand it so if you have specific questions I can help, I do not think I will be able to stay after class though. What I am having trouble with is on the last query does anyone know how to count the total number of people from Washington and Oregon states? The only thing I seem to be getting is the number of times they have an issue which is more than the actual customers. I would appreciate the help if anyone has done it already. Thanks!

I haven't gotten to the last query yet because I'm still stuck on the fifth one where we had to calculate the costs of each customer. The way I did it was I made a field with the Issue ID and then I used the Count feature on there to get the total number of issues per customer. Then I created another field and used this formula: Costs of Customer: 30*[Count of Issue ID]. This worked but it wouldn't allow me to hide the column containing the Count of Issue ID and I wasn't sure how to add dollar signs to the total costs.

This is how it looked:

Contact Name State Count of Issue ID Costs of Customer

How do I hide that third column and how do I add dollar signs to the Costs of Customer?