query in a project

[krberube]

I have a succesfull .mdb, and would now like to start "testing the waters" of a project file. I designed a query from 5 table. If i leave the criteria blank the query runs fine. If i place criteria for a user prompt the SQL looks like this and i get no prompt and no data.

WHERE (dbo.[TLA Unit].TLAUnit = N'[enter sn]')

Any explanation would be appreciated.
Kevin

 

[krberube]

I figured it out. I had to build an "In-Line function" instead of the straight query i had done.
The "N" that was inserted into the SQL statement is because the field is a data type "nvarchar"