If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
QBE inserts quotes instead of brackets around field names
Is there anything that I can do to control whether the QBE inserts
quotes or brackets around field names when I type expressions into the QBE? For example, if I want to do an update query in a new field that grabs the first character of OLDFIELD, left(oldfield,1) gets interpreted as left("oldfield",1) instead of left([oldfield],1). It seems to me that up until about Access 2003, the program was pretty good at detecting field names and would put in the brackets automatically - but in Access 2003, it seems to default to quotes, and I have to remember to include the brackets, which is not easy after so many years of not having to do so. |
#2
|
|||
|
|||
QBE inserts quotes instead of brackets around field names
Sorry, but I think you'll have to use your brain a little! As far as I can
remember, it was the same in version 2000, and I can't really believe that this is something that would change. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
QBE inserts quotes instead of brackets around field names
"gebelo" wrote in message
... Is there anything that I can do to control whether the QBE inserts quotes or brackets around field names when I type expressions into the QBE? For example, if I want to do an update query in a new field that grabs the first character of OLDFIELD, left(oldfield,1) gets interpreted as left("oldfield",1) instead of left([oldfield],1). It seems to me that up until about Access 2003, the program was pretty good at detecting field names and would put in the brackets automatically - but in Access 2003, it seems to default to quotes, and I have to remember to include the brackets, which is not easy after so many years of not having to do so. I don't recall it as ever being different. You have to put in the brackets yourself. -- Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html (please reply to the newsgroup) |
#4
|
|||
|
|||
QBE inserts quotes instead of brackets around field names
Well, when I use my brain, I use MSSql or MySQL.
That not always being the case, if you have older versions lying around and are curious, give it a try. On my home machine (access 2002), I type in any expression and it puts in the brackets by default. Same expression on a work machine, I get quotes by default. This happens, by the way, in the criteria or in update queries. if I type in an expression as a field, it still gets the brackets right.... On Mar 26, 11:56*am, "Dirk Goldgar" wrote: "gebelo" wrote in message ... Is there anything that I can do to control whether the QBE inserts quotes or brackets around field names when I type expressions into the QBE? For example, if I want to do an update query in a new field that grabs the first character of OLDFIELD, left(oldfield,1) gets interpreted as left("oldfield",1) instead of left([oldfield],1). It seems to me that up until about Access 2003, the program was pretty good at detecting field names and would put in the brackets automatically - but in Access 2003, it seems to default to quotes, and I have to remember to include the brackets, which is not easy after so many years of not having to do so. I don't recall it as ever being different. *You have to put in the brackets yourself. -- Dirk Goldgar, MS Access MVP Access tips:www.datagnostics.com/tips.html (please reply to the newsgroup) |
Thread Tools | |
Display Modes | |
|
|