SELECT CustNum , Count(SupplierTransID) As TransCount , Count(SupplierTransID) * 2 AS DoubleTransCount FROM SupplierTrans GROUP BY CustNumHowever, Access doesn't seem to want to calculate the DoubleTransCount field using the same concept. I get a "Syntax error (missing operator) in query expression... '. Why can't Access handle this query? Do I need to be doing it differently?