SQL statement

Hi All,
My DB is Access.I'm trying to pull data from access database into an XML file.I'm able to pull the data.But when I try to apply WHERE clause in my sql statement,it doesn't work and is giving me the syntax error.
Here is my SQL statement,

.Source = "SELECT * FROM ([GrantNet],[Categories]) " & _
"WHERE GrantNet.Issue_Number= 01-11"

I'm not sure what mistake I'm doing.Any help is appreciated a lot.Thanks,
Fun

I am assumng the IssueNumber is a text field. If so

"WHERE GrantNet.Issue_Number= '01-11' "

It is textual string and 01-11 means that it's November'01.I 'm working on this database and I'm trying to generate an XML file from the database.I'm using ADO to generate it which creates the schema and the data file.And then I use another stylesheet to generate traditional XML file from ADOXML file.
But after using single quotes ie
.Source = "SELECT * FROM GrantNet,Categories where GrantNet.Issue_Number='02-11'"

I'm getting a ADOXML file which creates only schema and not the data from the access.

Don't know what to do
Thanks,
Fun

What is categories referenceing?

S-