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

I agree. It was really hard to get to where I wanted to go in 2007.

I will try again. I think perhaps I didn't present a proper example of my issue.