Access Code Help

[Steve Jobs]

Hello Experts,


What i am trying to do is to find the FCR% from the table, Calculation is COUNT of Ticket_number/FCR FLAG where FCR Flag = 1.


I tried the below but going wrong somewhere

SELECT Format((COUNT(B.FCR))/(COUNT(B.Ticket_Number)),'#.##%') FROM (SELECT COUNT(A.[FCR Flag]) AS FCR FROM(SELECT DATA.Ticket_Number, DATA.Month, DATA.Weekday, DATA.State, DATA.Region_Name, DATA.[FCR Flag]
FROM DATA
WHERE (((DATA.Month) Like [Enter Month] & "*") AND ((DATA.Weekday) Like [Enter Weekday] & "*") AND ((DATA.State) Like [Enter State] & "*") AND ((DATA.Region_Name) Like [Enter Region_Name] & "*" )))  AS A where A.[FCR Flag] =1) As B;