Search results

Hi Peter, yes Vv_Trans is formated as number, the reason for this is that tblMaster is constructed by data from other calculations and I thought it was to time consuming to enter Format([tbl]![field], "# ###") in every string since the data in tblMaster is used to display values in other forms...

Hi, I’m been searching this and other forums for the answer to this question. I'm trying to append data from one table to another through VBA but get a run-time error messages saying “Data type mismatch in criteria expression”. If I run the same code in a query in access I get the message that...