count value list in a query and report

[desireemm1]

Hi everyone I have an issue and its in access, so I'm struggling with converting a select statement from SQL to Access 2010. Ugh I miss sql. anyone I have this statement that I am trying to run but I keep getting an error message: I have it s an image



I'm trying to calculate Each value in my [Customer Type] combo box. like how many hang-ups or how many Unknown calls. When I did this in sql I did it in reporting services in a matrix, different database though. This is access and I am struggling with it can anyone please help I really gota get this done.

the combo box values:
GOV
HANG-UPS
APS
UNKNOWN
CLINIC


AND I need to total on each one.

GOV - 5
HANG-UPS -7

I have no idea how


SELECT
[Message Tracking].[User Retrieving],
[Message Tracking].[Date Retrieved],
[Message Tracking].[Date & Time Left],
[Message Tracking].[User Returning],
[Message Tracking].[Date Returned],
[Message Tracking].[Caller],
[Message Tracking].[Customer Type]


FROM [Message Tracking]
WHERE

( Message Tracking].[Date & Time Left]) Between [Begin_Date & Time Left] And [Ending_Date Returned)

[JoeM]

It wouldn't work as you have written it in SQL either. You have typos in your WHERE clause (too many parens, missing a square bracket).
It should be:

WHERE 
([Message Tracking].[Date & Time Left] Between [Begin_Date & Time Left] And [Ending_Date Returned])

[desireemm1]

Oh thank you Joe, my main problem is that I need to Add the Values in the combo box [Customer Type]

does DCount(GOV, APS, HANG-UPS) AS TypeCount


I have to have a total number of how many

GOV
APS
HANG-UPS

basically I have to show in a report how many times there was a hang-up, APS, GOV, etc...

[June7]

How many different customer type values are there? Do you want a count for each or just one count all together?

A CROSSTAB query could probably produce the individual count (like a matrix). However, building a report to run perpetually based on a CROSSTAB is not easy.

Could use report Grouping & Sorting features with aggregate calc in group footer. Set a Grouping on the CustomerType field.

Or an aggregate query could generate the single composite count.
SELECT Count(*) AS CountGAH FROM tablename WHERE CustomerType IN("GOV", "APS", "HANG-UPS");

Not sure how a combobox is involved in generating this output.