[table]![field] not retaining brackets

  • Thread starter Thread starter Whiillleeee
  • Start date Start date
W

Whiillleeee

I have several queries in my Access DB that will not save
the brackets on my tables associated with a table/field
parameter call.

Here is an example:

HILO: IIf(NEW![52HI]>HOMETEX_TIX![52HI] Or [HIGH]
HOMETEX_TIX![52HI],"(H)",IIf(NEW![52LO]<HOMETEX_TIX!
Click to expand...
[52LO] Or [LOW]<HOMETEX_TIX![52LO],"(L)"," "))

As you can see, the tables do not have the brackets, and
this seems to be giving me bad query results.

I believe this happened when I switched to Access 2002
from Access 2000.

I am on Windows XP Pro.

Any help appreciated.

Thanks
Whiillleeee
 
You can manually add the brackets to the table names.

What are you referring to as the "Parameter Call"?

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Whiillleeee said:
I have several queries in my Access DB that will not save
the brackets on my tables associated with a table/field
parameter call.

Here is an example:

HILO: IIf(NEW![52HI]>HOMETEX_TIX![52HI] Or [HIGH]
HOMETEX_TIX![52HI],"(H)",IIf(NEW![52LO]<HOMETEX_TIX!
Click to expand...
[52LO] Or [LOW]<HOMETEX_TIX![52LO],"(L)"," "))

As you can see, the tables do not have the brackets, and
this seems to be giving me bad query results.

I believe this happened when I switched to Access 2002
from Access 2000.

I am on Windows XP Pro.

Any help appreciated.

Thanks
Whiillleeee
Click to expand...
 
Back
Top