Search results

Hello again all, We have a form with a text box called txtEditHaul (format is Fixed) and when a user types a figure in this field it needs to update a couple of Currency fields in a table. This is the original VBA code in the After Update of the box: DoCmd.RunSQL ("UPDATE [Order Details] SET...

Hello all, I am currently trying to grapple with the Round function in Access. I should start by saying that I know Access uses "banker's rounding" and this is actually what I want it to do, however I am finding that even this doesn't appear to be functioning as I want it to. For example...