hello forum.
I get a runtime error 3464 data type mismatch in criteria expression
when doing this sql:
mysql = "SELECT tblLoads.Ref, tblloads.contents, tblloads.[destination port], tblLoads.Carriers, tblLoads.[Ship Date], tblLoads.[Est Arrival], tblLoads.Brokers, tblBrokers.[ISF email], tblbrokers.[co name], tblcarriers.scac , tblSuppliers.isf INTO tbltemp FROM tblloads, tblcarriers, tblbrokers, tblsuppliers Where tblloads.do = 'yes' order by tblloads.brokers, tblLoads.[Ship Date], tblloads.carriers, tblloads.[destination port] "
DoCmd.RunSQL mysql
I got a variety of different errors while working through this statement's syntax and even didn't include the FROM clause initially.
Yet, this statement still has troubles and I can't find anything else to do with it to make it work.
It general it gets data from 4 different tables and puts it into a new one (tbltemp) , though not previously created but vba ?supposedly? will create it due to the INTO <tablename> thats there.
So for now I'm official stuck, please help, thanks.
I get a runtime error 3464 data type mismatch in criteria expression
when doing this sql:
mysql = "SELECT tblLoads.Ref, tblloads.contents, tblloads.[destination port], tblLoads.Carriers, tblLoads.[Ship Date], tblLoads.[Est Arrival], tblLoads.Brokers, tblBrokers.[ISF email], tblbrokers.[co name], tblcarriers.scac , tblSuppliers.isf INTO tbltemp FROM tblloads, tblcarriers, tblbrokers, tblsuppliers Where tblloads.do = 'yes' order by tblloads.brokers, tblLoads.[Ship Date], tblloads.carriers, tblloads.[destination port] "
DoCmd.RunSQL mysql
I got a variety of different errors while working through this statement's syntax and even didn't include the FROM clause initially.
Yet, this statement still has troubles and I can't find anything else to do with it to make it work.
It general it gets data from 4 different tables and puts it into a new one (tbltemp) , though not previously created but vba ?supposedly? will create it due to the INTO <tablename> thats there.
So for now I'm official stuck, please help, thanks.
