Input Images

[Noah114]

I have a report, and what I would like to do is generate something where is sales increase, bring in a picture and if they decrease to bring in a separate picture. How do I link?

 

[THWatson]

Noah114
You haven't indicated how your report is laid out - what sales are shown. You also haven't indicated where the picturss are stored.

However, assuming that the pictures can be added to your query that drives the report...and assuming that your report is something like this:
June 2006 $200 in sales
July 2006 $400 in sales

Something such as this:
1. Put an unbound text box on the Detail section of your report. Let's call it txtSalesTotal. Make it a running sum. If you don't want it to show, set it to not visible.
2. Put an unbound image control on the Detail section of your report. Let's call it imgSales.
2. On the OnFormat event for the Detail section, put the following code:

If Me.txtSalesTotal > 0 Then
Me.imgSales = Whatever Picture you want when sales increase
Else
Me.imgSales = Whatever Picture you want when sales decrease

Since there isn't complete information to go on, you may have to tinker with what I have suggested to get it to work properly. However this may point you in the right direction.

Tom

 

[TheAceMan1]

How are ya Noah114 . . .

[blue]Increase or decrease in reference to what?[/blue] . . . the value in the previous record?

See Ya! . . . . . .