Insert Image associated to specific value

[albe_ACC]

Hi guys!
I'm building a report: I have a field (let's call it "Result") that I want to associate to a specific image.
For example, when field "Result" equals 1, I want the report to display a specific image/icon (for example a ); when field "Result" equals 0, I want the report to display another image ( ).
DO you know if there's a way to do it?
Thank you very much for your help!!

AL!

[June7]

Is it only the 2 images? One way is to have image control for each image set to not visible and then VBA code in the Format event of section of report where images are located would make one of the image controls visible. This will not work in Detail section if multiple records are reported.

Another method is to use the ControlSource property of image control to dynamically display image. The property could be set to a field of table that has the image stored or the path to the image in folder.

[hertfordkc]

My test is too big to attach, probably because of the size of the images I chose.
Here's what I did:
1) Created a table with one column, Result.
2) Created a table with two columns, ID and Image.
3) Created a query with a calculated column based on the value of the result field, e.g. if Result <= 1, then ImageID = 3, else ImageID = 4.
4) Created another query based on step 3 which has a result column, an imageID column and an image column.
5) Created a report based on that query.
Try it. If it doesn't work, I'll try to put in smaller images and post the DB.

[June7]

Run Compact & Repair, zip, is it still too big - up to 2mb zip allowed.

[albe_ACC]

Thank you very much guys!
I'll try hertfordkc trick today!

[hertfordkc]

testz.zip is what I tried to describe above.
Thanks, June7