Recent content by HansSteyn

<>"FINAL INVOICE" means not Sold

There is a status field called InvStatus and in the query the criteria for this field is <>"FINAL INVOICE". I know what you mean by the sellingDate but that is unfortunately not available since the same field is used for the offers, so I need to hide the 2 offers.

Hi All Many offers can be made to sell a specific vehicle (which has only one stock number - let's say filed INVSTOCKNR is 9750) but at the end of the day that stock number can only be sold once. I have to make a monthly Police Acquisition Register report. So if there were 3 offers made on...

I am from South Africa where, in 1997, I have developed a Dealer Management System for independent second-hand vehicle dealers using MS-Access. I got stuck with Access 2003....