I have created an append query that adds records to a database based on the data in a form. I have set up the query to round one of the calculated fields to 2 decimal places before it posts to the database.
When I am in design mode and preview the file, the field is correctly rounded (and truncated) and everything looks as it should - even when you click on the field. However, when it adds the record to the table it is updating the record with the unrounded amount. I am very puzzled, because the preview file looks correct (even when you click on the field - it is correctly truncated). Here is the code that rounds the calculated field:
Int((Amount*Rep_Rate_5*Pending_Pmt*100))/100)
Any idea what would be causing this?
When I am in design mode and preview the file, the field is correctly rounded (and truncated) and everything looks as it should - even when you click on the field. However, when it adds the record to the table it is updating the record with the unrounded amount. I am very puzzled, because the preview file looks correct (even when you click on the field - it is correctly truncated). Here is the code that rounds the calculated field:
Int((Amount*Rep_Rate_5*Pending_Pmt*100))/100)
Any idea what would be causing this?
