# in String

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I run the code below, it hangs at the # . How do I let it know that the
# symbol is being used as a string criteria? I tried taking the double
quotation in #D and stil does not work. Thanks

ALSO< this is the first time I will be using RUNSQL command. Do I need any
DIM or Set statements ??

DoCmd.RunSQL"SELECT [tbla].Card, [tbla].Date, [tbla].TfrPDM, [tbla].AddDel,
[tbla].Delete FROM [tbla] WHERE ((([tbla].TfrPDM)=-1) AND
(([tbla].AddDel)="#D"));"
 
Hi,

MN schreibselte:
When I run the code below, it hangs at the # . How do I let it know
that the # symbol is being used as a string criteria? I tried taking
the double quotation in #D and stil does not work. Thanks

ALSO< this is the first time I will be using RUNSQL command. Do I
need any DIM or Set statements ??

DoCmd.RunSQL "SELECT [tbla].Card, [tbla].Date, [tbla].TfrPDM,
[tbla].AddDel, [tbla].Delete FROM [tbla] WHERE ((([tbla].TfrPDM)=-1)
AND (([tbla].AddDel)="#D"));"
Click to expand...

Use ' around "#D"

....AND (([tbla].AddDel)='#D'));"

Acki
 
Back
Top