G
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
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