Question On Setting Up Simple "If" Logic For a Report

[forthemame]

Hello,


I'm trying to setup a check box for an existing report. The report lists items from an inventory table. I'm trying to add a new column called "Computer" that will display a check box (or a YES flag or something) next to any item in the report if it is a computer.

Computers are denoted in the data by the 'Code' field from the 'inven' table. If the Code is equal to 25, then the item is a computer.

I figure the logic would be something similar to this: If ( Code = '25' ), Print ('Yes'), Else Print (' ')

If there's a way to actually put a check in the text box, then that'd be great too. I suppose it's not mandatory, but nice to have.

I played around with the expression builder, but I couldn't figure out how to do this seemingly simple add-on. I have the 'Computer' heading showing up fine, but the check box and associated logic is a bit harder. Any thoughts?

Thanks.

[pbaldy]

Try this as the control source of a checkbox in the report:

=IIf(Code = '25', True, False)

Drop the quotes around 25 if the Code field has a numeric data type.

[forthemame]

Try this as the control source of a checkbox in the report:

=IIf(Code = '25', True, False)

Drop the quotes around 25 if the Code field has a numeric data type.

Thanks for the reply. When I run the report, it prompts me for the Department (as expected) but it's also prompting me for the Code value. Even if I enter 25, it returns -1 in the Computer column for every item in the inventory.

Any idea what's going on?

[pbaldy]

Well, "Code" would have to be your actual field name, and that field would need to be in the report's source table/query.

[forthemame]

Well, "Code" would have to be your actual field name, and that field would need to be in the report's source table/query.

How do you check the source of the Report? Sorry for the lame questions.
Thanks.

[pbaldy]

The source of the report is the Record Source property of the report. It could be a table, a saved query, or SQL.

[forthemame]

The source of the report is the Record Source property of the report. It could be a table, a saved query, or SQL.

Ah ha! I found the source, added the 'Code' field, and added the following to the Control Source of the Code 'checkbox':
=IIf([Code]='25',True,False)

Now, it seems to be displaying 0 for False and -1 for True for each of the items. Is there any way I can change this to Y and N, or T and F, or something a little more useful?

Thanks!

[pbaldy]

It sounds like you used a textbox instead of a checkbox. A checkbox would either be checked or not. If you want to stick with the textbox:

=IIf([Code]='25',"T","F")

or whatever you want to display in place of the T and F.

[forthemame]

It sounds like you used a textbox instead of a checkbox. A checkbox would either be checked or not. If you want to stick with the textbox:

=IIf([Code]='25',"T","F")

or whatever you want to display in place of the T and F.

Ah, I probably did use a textbox as I just copied an existing box on the page. I'll go look up checkboxes and see if that works.

Thanks!