C
Chlaris
Dear all,
I create a query with the following criteria :
Like Nz(Forms!frmReport!cboProjectCode,"*")
The value of Forms!frmReport!cboProjectCode is "AI-LC2050 TC#7"
After I run the query, it returns no record.
But if I change the criteria to : Forms!frmReport!cboProjectCode, it returns
several records.
Is it right that I can't use Like statement with field value contains # ?
Thanks.
Chlaris
I create a query with the following criteria :
Like Nz(Forms!frmReport!cboProjectCode,"*")
The value of Forms!frmReport!cboProjectCode is "AI-LC2050 TC#7"
After I run the query, it returns no record.
But if I change the criteria to : Forms!frmReport!cboProjectCode, it returns
several records.
Is it right that I can't use Like statement with field value contains # ?
Thanks.
Chlaris