AND comparison

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to enter an expression in a conditional formatting field, and
obviously am missing something.

I'm trying to format an item green if the date is > than another date (the
[open] field date) and > than today.

something like
 
I would think it would be...
[Open] and >Date()
Click to expand...


But, I would be a bit leery of using "open" as a field name. I don't know
if it is a reserved word, but it seems like something that could be. I try
to use more specific names like "DateOpened".

--
Rick B



xfngrs said:
I'm trying to enter an expression in a conditional formatting field, and
obviously am missing something.

I'm trying to format an item green if the date is > than another date (the
[open] field date) and > than today.

something like
[open] AND Date() but I keep getting invalid syntax messages
Click to expand...
Click to expand...
 
I would think it would be...
[Open] and >Date()
Click to expand...

But, I would be a bit leery of using "open" as a field name. I don't know
if it is a reserved word, but it seems like something that could be. I try
to use more specific names like "DateOpened".
Click to expand...

Yes it is a keyword.

Open is a reserved Access/VBA/Jet word and should not be used as a
field name.
For additional reserved words, see the Microsoft KnowledgeBase article
for your version of Access:

109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'
 
Back
Top