Need a little direction 1

[bra1niac]

Can anyone tell me where to find some information concerning Access' syntax?

For example, I know how to create a simple query, and use the Like [] to prompt for input. That's about it. I have tried using different operators from different languages I know and, frankly, I knew it wasn't going to work.

Short of going to the bookstore, can anyone point me in the right direction?

This is one of those situations where the company said, "Let the Web Developer do it." And here I sit with little knowledge of Access and a HUGE task ahead.

Thanks. "Absorb what is useful, discard what is not. Add what is uniquely your own." - Bruce Lee - The Tao of Jeet Kune Do

 

[Tim1]

Hiya,

Basically, Access will accept most (not all, but a lot) of standard SQL commands. As a good starting point, you could try some SQL tutorials on the web. One of the others here has suggested a couple,

http://www.sqlcourse.com

and

http://www.sqlcourse2.com.

Hope that gives you a start. After that, do a search on the next for MS Access and see what gets found,

good luck,

Tim

 

[WP]

Try searching for it e.g. on

http://www.google.com

serach for Microsoft ACCESS syntax

http://msdn.microsoft.com/library/officedev/off2000/acconComparingAccessSQLSSQLSyntax.htm

Bill Paton
william.paton@ubsw.com

http://www.neptune400.co.uk/

Check out

http://www.deepturtle.ch

 

[PamelaG]

Hi!

A good reference book is the DDC Access 2000 reference guide. I give these to all of my students and clients for all the Office apps. You can get these at any bookstore (they may have to order them) or directly from the publisher:

http://www.ddcpub.com/htmlnew/results3.asp?id=638

This is worth every penny of the rather modest price, I promise!

Pamela

http://www.accessinsight.com