Expressions in Microsoft Query
 

In Microsoft Query, is it possible to create calculated fields? I've used
the help within Microsoft Query and followed the instructions for creating an
expression, but no matter what I try, I get error messages saying that it
can't find expression in the tables selected. I've tried coding in the
calculations in the SQL Statement, but still error messages. Even when I try
to sum button on the toolbar I get errors.

Is this functionality not available within Microsoft Query? All I'm able to
do is filter, which is helpful, but still leaves much more then is practical
to be done in excel. I'm hoping to avoid using Access if at all possible.

Thanks in advance

Expressions in Microsoft Query
 

Can you post what you've tried ?

Tim


"eggman" wrote in message
...
In Microsoft Query, is it possible to create calculated fields?
I've used
the help within Microsoft Query and followed the instructions for
creating an
expression, but no matter what I try, I get error messages saying
that it
can't find expression in the tables selected. I've tried coding in
the
calculations in the SQL Statement, but still error messages. Even
when I try
to sum button on the toolbar I get errors.

Is this functionality not available within Microsoft Query? All I'm
able to
do is filter, which is helpful, but still leaves much more then is
practical
to be done in excel. I'm hoping to avoid using Access if at all
possible.

Thanks in advance