[] and ""

[thread]

Hi,
it might be a stupid question but that is the diffrence between [] and
"" when it metter of updating and creating new tables?

 

[Guest]

Hi Thread,

It's not a stupid question. Square brackets are used to indicate field names
or to prompt the user for input, as in a parameter query. Quotes are used to
tell the JET database engine that the value is a string. Usually, quotes will
be added automatically, but not always, especially if you have used special
characters such as a space, or a hyphen, which can be interpreted as minus
sign.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[John W. Vinson]

Hi,
it might be a stupid question but that is the diffrence between [] and
"" when it metter of updating and creating new tables?

Square brackets [ ] are delimiters for Access objects - fieldnames,
table names, form and control names, and so on.

Doublequotes (or singlequotes ') are delimiters for literal text
strings.

So

"Banana"

will be the literal six-letter text string "Banana".

[Banana]

will depend on the context - in a query or a table, it would be the
value of the field named Banana (or generate a prompt to the user if
there is no field of that name).

John W. Vinson [MVP]

 

[thread]

thank you both

John W. Vinson כתב:

Hi,
it might be a stupid question but that is the diffrence between [] and
"" when it metter of updating and creating new tables?

Square brackets [ ] are delimiters for Access objects - fieldnames,
table names, form and control names, and so on.

Doublequotes (or singlequotes ') are delimiters for literal text
strings.

So

"Banana"

will be the literal six-letter text string "Banana".

[Banana]

will depend on the context - in a query or a table, it would be the
value of the field named Banana (or generate a prompt to the user if
there is no field of that name).

John W. Vinson [MVP]