rounding to 2 decimal places

[Guest]

I have a querry with the following (example
number of cards(A) amount per card (B) total amount ( A*B)
Both B and A*B are formated as 2 decimal place

I have another query simlar to above.

The two querries are joined by an SQL statement. BUT the "total Amount" results in the joined querry gives me the amount in 4 decimal places or more. I have tried to format in sql on the field names, but still cannot get the rquired 2 decimal places. can someone help

 

[fredg]

I have a querry with the following (example)
number of cards(A) amount per card (B) total amount ( A*B)
Both B and A*B are formated as 2 decimal places

I have another query simlar to above.

The two querries are joined by an SQL statement. BUT the "total Amount" results in the joined querry gives me the amount in 4 decimal places or more. I have tried to format in sql on the field names, but still cannot get the rquired 2 decimal places. can someone help?

Exp:Format([A]*,"#.00")

 

[MGFoster]

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

If you are using Access XP, or higher version, you can use the Round()
function on the final result (total amount). E.g.:

Round(TotalAmount, 2)

will round the value, TotalAmount, to 2 decimal places.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBQMYAtoechKqOuFEgEQKlOACgzCB0U+y6tTOt3t49fFgBLu379I4Amwd5
ofms35Ba3RprePeat57upC/H
=NO6Q
-----END PGP SIGNATURE-----

 

[Guest]

format does not work
I need the rounding function, but i have access 97 and there is nothing about rounding ih HELP