SQL help in Access?

F

Fred Boer

Hello!

I saw a bit of SQL in a post tonight that used the word "Transform". I
haven't seen that before, and thought, "Hey, I'd like to look that up...".
But, I can't seem to find anything on SQL in the Access "Help". I think it
must be in there, though... Any ideas how to find it?

Using Access 2002.

Thanks!
Fred Boer
 
V

Van T. Dinh

The indexing in Help is terrible but TRANSFORM is there.

Look in the Help Contents tab. About the 4th last "book"
is Microsoft JET reference (remember this "book" for
everything about JET SQL) then Data Manipulation Language
and you will see TRANSFORM.

Skim through this "book" and you will find a lot of info
about JET SQL.

HTH
Van T. Dinh
MVP (Access)
 
F

Fred Boer

Dear Van:

Thanks very much, but I'm not seeing this... We are talking about the main
Access Help, not the VBA help, correct? I'm using Access XP (2002)...

Last 5 in my contents are:

Microsoft ActiveX Data Objects (ADO)
Microsoft Data Access Objects 3.60 (DAO)
Microsoft Office Web Components Visual Basic Reference
Microsoft Office Visual Basic Reference
Language-Specific Features

Am I nuts?

Fred
 
V

Van T. Dinh

Yes, the main Access Help, not VBA Help.

I have the 5 you listed + Microsoft JET SQL Reference (as
the 4th last item) in A2002 SP2 but IIRC, it is the same
(including A2000) regardless of SP.

Try repairing your Office / Access installation and see if
the Microsoft JET SQL Reference appears.

HTH
Van T. Dinh
MVP (Access)
 
A

Albert D. Kallal

Hum, in a2003, I get:


About XSL transformation file

TRANSFORM Statement

INNER JOIN Operation

Import or link data objects

Export Access data as XML

About XML data and access

Comparison of Microsoft JET SQL and ANSI SQL

SQL reserved words

There is a few more (11 total hits for the word transform). The above hits
are with on-line help disabled!. So, the 2nd "hit" would likely be the one
we want...clicking on it we get, here is a screen shot:

http://www.attcanada.net/~kallal.msn/test/trans.htm

A number of people have remarked that a2003 help is not perfect..but
certainly the best it has been since a97. I find it is REALLY very nice, and
the above screen shot shows just how so. Note the above hit list also have
nice suggestions such as "sql reserved words", and the comparison of JET sql
and ANSI sql....really very nice stuff....
 
K

Ken Snell [MVP]

Fred -

I sent you (your private email) a screen shot showing how to get to
Transform in ACCESS 2002 Help.
 
D

Dirk Goldgar

Fred Boer said:
Dear Van:

Thanks very much, but I'm not seeing this... We are talking about the
main Access Help, not the VBA help, correct? I'm using Access XP
(2002)...

Last 5 in my contents are:

Microsoft ActiveX Data Objects (ADO)
Microsoft Data Access Objects 3.60 (DAO)
Microsoft Office Web Components Visual Basic Reference
Microsoft Office Visual Basic Reference
Language-Specific Features

Am I nuts?

Fred
Click to expand...

Fred, I'm with Van on this. The SQL book ought to be there. Search
your system for the file "JETSQL40.CHM". Is it there? What folder is
it in?
 
G

Guest

OK. Found a bit more details about JET SQL:

This "book" in Access Help is a link to a separate Help
file "JETSQL40.CHM".

If repairing Office / Access doesn't help, simply find
this file "JETSQL40.CHM" and open it separately. You
should have the same info. as per the Microsoft JET SQL
Reference "book" in Access Help.

I found this file in my PC in the directory:

C:\Program Files\Common Files\Microsoft Shared\
Office10\1033

HTH
Van T. Dinh
MVP (Access)
 
F

Fred Boer

Well, you can't see what isn't there! My installation of Access *is* missing
the "JETSQL40.chm" file. I'll have to repair the installation!

Thanks, everyone, for your help!

Cheers!
Fred
 
F

Fred Boer

Hi Albert:

The help system sounds like it is improved in 2003... I've tried doing a
search for "TRANSFORM" on my work computer (which does have the JETSQL40
file available), and neither the Index nor the Answer Wizard returns any
hits with the word TRANSFORM in them.

However, I *do* have the "book", and have found the appropriate information
using the table of contents...

All the best!
Fred
 
J

Joan Wild

Albert said:
Hum, in a2003, I get:

There is a few more (11 total hits for the word transform). The above
hits are with on-line help disabled!. So, the 2nd "hit" would likely
be the one we want...clicking on it we get, here is a screen shot:
Click to expand...

And don't forget that new in 2003, you can get context sensitive help in SQL
View. Just start a new query, go to SQL View and type 'transform' and hit
F1.
 
Top