[table]![field] loosing brackets

W

william

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

[table]![field] not retaining brackets 1
Replace Parentheses with Bracket in Subquery 1
Why does my query put brackets around some fields from my table and not others? 3
Parameter Query Question 5
QBE inserts quotes instead of brackets around field names 3
Update Query - One Field, Mutiple Posibilities... 4
Tip: Table design and query for bracketed lookup 12
field in the table as number 1

Top