Expressions in Microsoft Query

[eggman]

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

[Tim Williams]

Can you post what you've tried ?

Tim


"eggman" <[email protected]> wrote in message
news:[email protected]...
> 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
>