summing calculated fields on reports and tables to include cents

[alejo8955]

I am creating a database to help track travel expenses. In my tables i have used calculated fields. one of the fields is to "total expenses." In a report, i need to show the sum of all the "total expenses", the filed populates in the report but the cents are missing. for example if the amount is 6080.40 it shows as 6080. how can i get around this? I have tried changing the decimal point value to 2 at which point the value turns to 6080.00 when it should be 6080.40 (i am a beginner at this i am assuming the answer will probably involve c++ or visual basic's, two concepts i am not familiar with.) I'd appreciate any help. thanks!

 

[Tophan]

In the design view of the table, go to the properties and change the format to standard, fixed or currency (whichever you prefer), then change the decimals to 2.

That should help.

 

[alejo8955]

view attachment