Report with values between 1 and 4; need a pic embedded depending on number

[snipe]

Hey guys,

Here is a pic of the crosstab that I made.

The numbers 1-4 denote an employees performance in a given field. Currently, we use something called a Dot Report. It is done in excel, and all manually. An employee looks at a value for a salesperson and drags a color coded dot image (a red dot, black dot, gold star, or double star) to the field. It allows us to see who is/isn't performing at a glance.



The crosstab that I linked is my attempt to automate this process of embedding images. Is there anyway that I could have access, or excel, automatically place an image depending on the number in the field?

Thanks guys

[June7]

What do you mean by 'crosstab that I linked'? Is this crosstab generated in Access? Or is it in Excel and you are linking to Excel?

Embed the images where? Crosstab queries are not editable. Images in Access display on forms and reports.

Can dynamically display image on Access report using Image control with an expression in ControlSource that references the path to an external image file.

However, building report based on crosstab to run perpetually is not easy because crosstabs are so dynamic, especially when pivoting on date value.

[snipe]

Sorry June, I worded that poorly. "Crosstab that I linked" was just referring to the image that I posted.

Here is an image of the actual dot report that we have now: So you can see what I am trying to accomplish.

I wanted to make a report off of that crosstab that I posted the image of. But instead of having a bunch of 1-4's, VBA could embed a tiny image of the appropriate "dot."

[June7]

You said that report is an Excel product?

Access is very different.

Images do not display in tables or queries.

Must use an Image control or OLEObject control on a form or report.

Several ways to accomplish dynamic display of images.

One might be to have a table with 4 records for the 4 images.

tblImages
Rating (number 1 - 4)
Image (attachment)

Join that table to the table of ratings linking on the rating number. Build CROSSTAB with the attachment field as the Value field using First function. However, I don't know if CROSSTAB can handle Attachment field. Even if it does, the issue of building report on a crosstab still applies.

Bing: Access dynamic crosstab
http://allenbrowne.com/ser-67.html