Symbol based on Range Hlp!

[dee]

I am creating a report that includes weight, blood pressure, etc. and have to
show a different picture (or symbol) that indicates Fine, Could be better,
Needs attention, for example.

So, I need a way to look at their result, compare it with normal ranges and
then have the correct picture appear.

Any ideas would be greatly appreciated!

 

[Jeff Boyce]

Dee

You posted in a newsgroup dedicated to queries (i.e., SQL statements) in MS
Access. It sounds like you are trying to format a report (check the
microsoft.public.access.reports newsgroup).

One approach to doing this might be to use a Select Case statement to
determine which criterion was met, and identifying the image file to display
for each Case (see Access HELP on Select Case).

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Klatuu]

I would do this in the report rather than in the query. It will execute much
faster. If you can supply some examples, perhaps I can provide a solution.

 

[dee]

Sorry! I had posted a previous query question and totally forgot I was still
in this part of the newsgroup!

My apologies - I will repost in the correct place, as I want to add this to
a report, not a query!


--
Thanks!

Dee

Dee

You posted in a newsgroup dedicated to queries (i.e., SQL statements) in MS
Access. It sounds like you are trying to format a report (check the
microsoft.public.access.reports newsgroup).

One approach to doing this might be to use a Select Case statement to
determine which criterion was met, and identifying the image file to display
for each Case (see Access HELP on Select Case).

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/