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]
