Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
CurrentDb.Execute "SELECT ZONE.CITY AS [DESTIN CITY], ZONE.PROVINCE AS [DESTIN PROVINCE], INTER.SERVICE, INTER.Class, INTER.Min AS [MIN], INTER.LTL, INTER., INTER.[1M], INTER.[2M], INTER.[5M], INTER.[10M], INTER.[20M] INTO [TEMP OUTPUT] FROM [ZONE] INNER JOIN INTER ON ZONE.TCOMBI = INTER.DTCOMBO WHERE INTER.SERVICE =" Chr(34) & [Forms]![Prov2Country]![seThe above statement is giving error at this point
rvicecombo ] & chr(34) & " And ZONE.[ZONE] = " chr(34) & "LOCAL" & chr(34) & " And INTER.[TCOMBO] Like userinput ORDER BY ZONE.CITY, INTER.Class;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Access 2010 Only Including Numbers After Certain Limit||3||42|
|MS Access VBA How To Collect and Total All The Values In a XML Files Tags and Return Them In a Message Box||4||43|
|How to use Recordset, returned from a SPROC as the recourdsource of a form.||24||48|
|Select category, subcategory in MS Access table field||7||42|
Join the community of 500,000 technology professionals and ask your questions.