Reference of SQL commands in Access?

[Peter]

Does anybody have (a link to) a reference of available SQL commands in
MS-Access? I know you can use SOME VisualBasic commands, but I cannot
find a reference anywhere!
Among other things, I need to use an IF command, like this:
SELECT IF (Field=5,"five" ,"not five") AS NewField FROM Table

I really need a reference on this! I havent been able to find
anything in the Access help files, or the MSDN library.
I am using ASP to access the database through Microsoft.Jet.O LEDB.4.0

[Peter Doering]

> Does anybody have (a link to) a reference of available SQL commands in

MS-Access? I know you can use SOME VisualBasic commands, but I cannot
find a reference anywhere!
Search the OH for "Microsoft Jet Database Engine SQL Reserved Words".
Among other things, I need to use an IF command, like this:
SELECT IF (Field=5,"five" ,"not five") AS NewField FROM Table

SELECT IIF([Field]=5,"five","not five") AS NewField FROM Table;

HTH - Peter

--
No mails please.

[Lyle Fairfield]

go**********@pb b.dds.nl (Peter) wrote in
news:df******** *************** ***@posting.goo gle.com:

Does anybody have (a link to) a reference of available SQL commands in
MS-Access? I know you can use SOME VisualBasic commands, but I cannot
find a reference anywhere!
Among other things, I need to use an IF command, like this:
SELECT IF (Field=5,"five" ,"not five") AS NewField FROM Table

I really need a reference on this! I havent been able to find
anything in the Access help files, or the MSDN library.
I am using ASP to access the database through Microsoft.Jet.O LEDB.4.0

When Jet 4.0 is installed

JETSQL40.chm is also installed.

Mine is in:
C:\Program Files\Common Files\Microsoft Shared\Office 10\1033. One can find
it using the Search Utility.

Double clicking on this file should present you with quite a good reference
to JET 4.0 SQL.

(You can also access the contents of this file through Access XP Help (in
the User Interface, not in the VBA Editor.)

User Defined and Native VBA functions can often be used in JET SQL. If they
work in a VBA module then they are likely to work in SQL in Access. But I
think
IF (Field=5,"five" ,"not five") would not work in a VBA module. Possibly you
could use:
IIF(Field=5,"fi ve","not five")
but I am not an expert on IIF, preferring to use other contstructions.

But how could they work in ASP? Access and VBA are not running when one
uses JET from ASP. ASP is running, and I guess, one might be using ADO to
connect to JET. One is usually restricted to the objects and methods of the
technologies one is using.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)