Conditional Formatting with 3 conditions

[MarcieFess]

I'm having to create a report that will print one of 2 graphics based on 3 conditions.

Here is a piece of code I have already (it's in the On Format of the report Detail):

  If ztblAustinNFPARateTotal.GrpSub = "Flammability 3" And ztblAustinNFPARateTotal.PhysicalState = "L" And ztblAustinNFPARateTotal.SumOfQOH >= 10 Then
    Me.imgFlam3L.Picture = "T:\CheckBoxBottom.png"
    Else: Me.imgFlam3L.Picture = "T:\CheckBoxTop.png"
  End If
  
  If ztblAustinNFPARateTotal.GrpSub = "Flammability 2" And ztblAustinNFPARateTotal.PhysicalState = "L" And ztblAustinNFPARateTotal.SumOfQOH >= 120 Then
    Me.imgFlam2L.Picture = "T:\CheckBoxBottom.png"
    Else: Me.imgFlam2L.Picture = "T:\CheckBoxTop.png"
  End If

There are 36 such items, which means that some of them bleed over into a sub-report. (I'm going to try to insert a picture of the first page of a similar report, so you can see the results. I've not been successful with pictures before).

I don't know of any other way to format this report than to type everything in as I have done, and just have a logic checker and 2 graphics...a CheckBoxTop and a CheckBoxBottom .

The report I'm working on now is a little different, and the source table isn't the same so I cannot use the same syntax as on this particular form.

I know I don't need the selection "Where StoreName = (Select StoreName etc" because I had the originating query get the StoreKey from the form that calls it, therefore the table has only the information for the particular store in question already.

I keep throwing errors. Right now I'm getting a compile error: syntax error.

Can anyone help me please?

Marcie

 

[Geotch]

Here's how I've solved the problem in the past. Create a table with the pictures. In your queries create the criteria that will select the proper record from the table of pictures. Once you have this you can bring in the picture to the report.

Hope that makes sense.