Gary Croxford
asked on
MS Access Type Mismatch in Query to Count Instances of a String
Thank you for looking at my question,
I am trying to build a query that counts the number of occurrences of a string "On Time" in a query but it falls over with a type mismatch - why is that and please how do I fix it?
SELECT
qry2015_Receipts_to_Report _Detail.[B P Id],
qry2015_Receipts_to_Report _Detail.[B P Name],
qry2015_Receipts_to_Report _Detail.[R ecd Year],
qry2015_Receipts_to_Report _Detail.[R ecd Month],
Count(qry2015_Receipts_to_ Report_Det ail.[Deliv ery Perfomance]) AS [On Time]
FROM qry2015_Receipts_to_Report _Detail
GROUP BY qry2015_Receipts_to_Report _Detail.[B P Id], qry2015_Receipts_to_Report _Detail.[B P Name], qry2015_Receipts_to_Report _Detail.[R ecd Year], qry2015_Receipts_to_Report _Detail.[R ecd Month]
HAVING (((Count(qry2015_Receipts_ to_Report_ Detail.[De livery Perfomance]))="On Time"));
I am trying to build a query that counts the number of occurrences of a string "On Time" in a query but it falls over with a type mismatch - why is that and please how do I fix it?
SELECT
qry2015_Receipts_to_Report
qry2015_Receipts_to_Report
qry2015_Receipts_to_Report
qry2015_Receipts_to_Report
Count(qry2015_Receipts_to_
FROM qry2015_Receipts_to_Report
GROUP BY qry2015_Receipts_to_Report
HAVING (((Count(qry2015_Receipts_
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.