I wrote the following Sql query in VB.
the query is:
SELECT T1.X, T1.Y,T1.Z,T2.R,T2.K
FROM T1 LEFT JOIN T2 ON T1.X = T2.X
WHERE (((T1.X) like "T*"));
1.I create a querydef of this command because I want to link a form to
this query,to display certain X's in T1.
2.Access forbidded this command and sayid can't run SELECT query.
3. in the where line ,I want to make the T* as SUB parameter as string
I have a problem with the & because T* is with ""
4.I want to delete the query after I exit the form.
what can you suggest to me to do please