Search results

Sorry, would not do it again.

Thanks for your help. The "!" on the front of the field made a difference. Not sure how, but it did. Got some reading to do, I guess. Regarding the comment "One of [Litres], [Price/L] and [Bill Cost] should be removed." Yes [Bill Cost] is not really needed, but it was a test field for the...

I been told I am missing the point. Okay let us same I am. I have updated the recordset so that it it appears in order that I want. This code is an event procedure on a button in a form. The Form and the code are using the same sorting (copy the SQL from the query straight onto the code.)...

Thanks, when I get the code to work I will deal with putting the records in a order that I want. The data contains information from several different cars in our fleet, so order will be an important issue, later. I have had message boxes throughout earlier versions of code, these messages...

Code was changed according to suggestions so far. So I have deleted the original post to save screen space. Please see code below