I am trying to run a query in Access. Here is the equivalent query in SQL Server:

SELECT
	CustNum
	, Count(SupplierTransID) As TransCount
	, Count(SupplierTransID) * 2 AS DoubleTransCount
FROM
	SupplierTrans
GROUP BY
	CustNum

However, 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?