multiplying values in a query

How could I create a query which multiples all the values in one field
of a table by 1000? Would it be done the same way to do the same thing
on a query from a query of table? Thanks.

Mat


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Put this expression in the first empty field in your query:
MyFieldX1000:[MyField]*1000

You would do the same thing on a query from a query of table.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdatasheet.com
www.pcdatasheet.com


"Matthew Kramer" <mkramer110@hotmail.com> wrote in message
news:41881a1e$0$14538$c397aba@news.newsgroups.ws.. .[color=blue]
> How could I create a query which multiples all the values in one field
> of a table by 1000? Would it be done the same way to do the same thing
> on a query from a query of table? Thanks.
>
> Mat
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it![/color]