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

I've tried it in Access 2007 (the menu so changed I hardly found my way around) and it worked just fine.