Invalid Field Name or Expression

[DaneS]

Hi,

I have a query that contains the fields:

Earnings | Hours| Efficiency: =[SumofEarnings]/[SumofHours] (the = is only here on the forum to prevent a smiley face from occurring)

Now, when I run this query, access doesn't recognize SumofEarnings and SumofHours and it asks me to input a value, at which point I just leave the option blank and hit OK. The query then works correctly and gives me the correct sums and does the division operation just fine.

The problem is when I reference this query in a crosstab query. I want the value displayed in my Efficiency column as the "Value" in the crosstab query.

The final product should be a table that looks something like this:

Date | Department 1 | Department 2 | Department 3 | etc. with the value of Efficiency in the table for each department, for each day. When I try and run the crosstab query it says "The Access database does not recognize '[SumofEarnings]' as a valid field name or Expression.

How can I get around this?


Thank you,

-Dane S.

 

[JHB]

Try to show you query, and if you have some sample data it would be good..

 

[DaneS]

I just figured it out thanks to another user's help. I needed to change the Group By option to Expression on my calculated field. Thank you though!

 

[boblarson]

Already answered here:
http://answers.microsoft.com/en-us/...pression/d74e3577-d8dc-4d05-baf0-7a76538499bc

 

[boblarson]

(the = is only here on the forum to prevent a smiley face from occurring)

By the way, the answer to this is to click on the GO ADVANCED button and then check the DISABLE SMILIES IN TEXT checkbox: