Show Images linked to Numerical field in multiple rows of a table

[davidf]

HI I want to be able to link and show a small image based on the numerical field in the adjacent column of the table

eg if table column had No 1 in it it would show image-1, if it had No 2 in the table it would show image-2 ( see tabkle below)
report currently pulls out all data required - just dont know how to get the number thats pulled out to link and show an image as well as number



Using MS access 2007

Ref No	Name	Level	Image - would show in this column	Date
002	A Bloggs	3	< based on number being shown here
908	B. donaldson	2	< eg image 2
568	Fred. Jones	4	< image 4
984	Albert Walker	1	< image 1
452	jone zebra	1	< image 1

[June7]

These images are stored in external folder, not an attachment field? Are the images similarly named, like: Level1.jpg, Level2.jpg, etc.

Use an Image control with a conditional expression in the ControlSource.

="PathToFolder\Level" & [Level] & ".jpg"

PathToFolder example:
"R:\Photos"

If this is a multi-user db, would require every user to have R: drive mapped on their computer.

I just tested UNC (universal naming convention) path reference which uses server name as reference: "\\servername\path\filename"

[davidf]

Many thanks for the reply below - but I didnt quite follow it .

where would you suggest I store the images ? they havent been put anywhere yet
how do I then add then into the report ?
does this code go into the qsel file or another file ?


thanks

David

These images are stored in external folder, not an attachment field? Are the images similarly named, like: Level1.jpg, Level2.jpg, etc.

Use an Image control with a conditional expression in the ControlSource.

="PathToFolder\Level" & [Level] & ".jpg"

PathToFolder example:
"R:\Photos"

If this is a multi-user db, would require every user to have R: drive mapped on their computer.

I just tested UNC (universal naming convention) path reference which uses server name as reference: "\\servername\path\filename"

[June7]

Place images in a folder located whereever you want.

Create an Image control on the report. The expression would go in the ControlSource property. This establishes a dynamic link to the images so that each record will display image relevant to it.