Re: Update Query - change negative currency values to positive

TDR wrote: 
I was just switching to Data*** view

This is what I've got - and when I look in the data*** view there is no change:

UPDATE SystematicPlans SET SystematicPlans.GrossAmount = Abs([SystematicPlans]![GrossAmount]);

Do I need to run the query to see the change? 

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

A... yes.  How else will the changes be made?  With the query design
view, or SQL view, showing, from the main menu toolbar, select Query >
Run.  Then look at the table.  The value should be changed.

BTW, the correct separator between table names and column names is a
period, not an exclamation point.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQnKylIechKqOuFEgEQKi/QCg4E8us8QMJm5Ssk8rq+w480NQgPcAnjfp
yphIHGeDtz5q21S6ZtZ7GiD6
=kFRZ
-----END PGP SIGNATURE-----
.