>Rolf Hopkins wrote:
> > This is way off topic and you should seek an MS Access help list.
>
> Excuse me. I am working in MySQL. I see no reference whatever
>to MS Access
>in my message. How do you
>figure this is "off topic?"
Sir, Rolf had no way of knowing that you didn't know that you were
dealing with SQL statements generated by MS Access wizards. Parts of
the statements have been altered by hand, but the over all style is
unmistakable. For those of us familiar with MS Access, it is obvious
that the SQL is not psuedo-SQL, but actual SQL created by MS Access
and referring to objects in an Access application.
> > [Zip Code Distance Extractor] could refer to any number of diff
>things such as a
> > column in a table, a table name, a field on a form.
>
> I suppose it could. There is no such table or column listed in the
>documentation that comes with this product.
It is a form in an Access application. From the SQL, you can
determine some of the names of the fields on the form. But that's all
I can tell you about it.
> > The "!" also has several different meanings and you should be
>able to find it in help files.
>
> Help files for what? According to the books I have, the "!" means "NOT" in
>the context of a SELECT clause.
In the context, it means 'menber of'. [Zip Code Distance Extractor]
is a form which is a member of the Forms collection (an object in an
Access database). [Zip Code] is a field which is a member of the [Zip
Code Distance Extractor] form.
Rolf quite naturally assumed that you were working with an Access
database application (and so did I), and was trying to direct you to
the Access help files.
Bob Hall
**** [EMAIL PROTECTED]
>>>> Know thyself? Absurd direction!
**** Command 'know' not recognized.
Drat. I wanted a list server and got an epistemological skeptic instead.
MySQL secret passwords: sql query database
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
