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