Please help with condition

  • Thread starter Thread starter ikh1
  • Start date Start date
I

ikh1

I have 2 fields, RECORDS which is numeric, and BINARY which is text. For the
report, I need to set the Records column to display the number from the
RECORDS field most of the time, except in cases when the BINARY field is
"Yes", then the RECORDS column in the report should read "n/a" instead. How
can I do this?
 
I have 2 fields, RECORDS which is numeric, and BINARY which is text. For the
report, I need to set the Records column to display the number from the
RECORDS field most of the time, except in cases when the BINARY field is
"Yes", then the RECORDS column in the report should read "n/a" instead. How
can I do this?
Click to expand...

Binary is a reserved Access/VBA/Jet word and should not be used as a
field name.
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'


After you change the [Binary] field name to something else:
As control source of an unbound control:
=IIf([BinaryField] = "Yes","n/a",[Records])
 
Back
Top