the expression is typed incorrectly or the query is too complex

[uapak90]

It just started happening to my query, I was trying to make another query like this one :

SELECT [Personnel (2008)].[Room/Location], (Abs(Sum([Personnel (2008)].[Alert]))) AS [# of Above Alert], (FormatPercent([# of Above Alert]/[Total Personnel Samples])) AS [% of Above Alert], (Abs(Sum([Personnel (2008)].[Action]))) AS [# of Above Action], (FormatPercent(([# of Above Action]/[Total Personnel Samples]))) AS [% of Above Action]
FROM [Personnel (2008)] INNER JOIN [Final - Total Samples By Date (Personnel)] ON [Personnel (2008)].[Room/Location]=[Final - Total Samples By Date (Personnel)].[Room/Location]
GROUP BY [Personnel (2008)].[Room/Location], [Final - Total Samples By Date (Personnel)].[Total Personnel Samples];

And I only got this far:

SELECT [Rodac Plates (2008)].[Room/Location], (Abs(Sum([Alert]))) AS [# of Above Alert]
FROM [Rodac Plates (2008)] INNER JOIN [Final - Total Samples By Date (Rodac Plates)] ON [Rodac Plates (2008)].[Room/Location] = [Final - Total Samples By Date (Rodac Plates)].[Room/Location]
GROUP BY [Rodac Plates (2008)].[Room/Location];

And it says that the expression is typed incorrectly or too complex.. happend to anyone else before?

 

[uapak90]

the first code works perfectly, the second one doesnt

 

[uapak90]

anyone .. help.. please!

 

[dhookom]

Try change to not group by and then remove one field at a time until it works. Tell us where the query breaks.

Duane
Hook'D on Access
MS Access MVP

 

[uapak90]

You know what happened, before, I had the "alert" and "action" fields as Yes/No, then I changed it to all text, but since I have check boxes, it just displays as either "-1" or "0", for the first query, I changed all the No's to 0, but for the second one, all my fields still had No in them, so it was probably awkward for access to sum up, "no".
STupid mistakes.