Using varibles in SQL

[OD]

I would like to upsize my data base, but I'm having a problem with the SQL
statement. I access 2007 I had to rap a varible into a function then use the
function in the access querry. How do I use a varible in a SQL statement. If
I use the @ it prompts me for input. I need to pass the a varible to the SQL
statement.

Thanks

OD

[Sylvain Lafontaine]

If you have upsized to a MDB (or ACCDB) database file with ODBC Linked
Tables, you shouldn't have this problem of passing a variables for your
current queries; so my thinking is that you have upsized to an ADP (Access
Database Project) project file. It's much more complicated to work with an
ADP project than with a MDB or ACCDB database file with ODBC Linked Tables.

Please provide more details on what you have done exactly.

Finally, the official newsgroup for ADP is
microsoft.public.access.adp.sqlserver but I'm not suggesting that you keep
going this way.
--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform

Blog/web site: coding-paparazzi.sylvainlafontaine.com

Post by OD
I would like to upsize my data base, but I'm having a problem with the SQL
statement. I access 2007 I had to rap a varible into a function then use the
function in the access querry. How do I use a varible in a SQL statement. If
statement.
Thanks
OD