Recent content by Fireman Sam

assuming 1 box (calling it colourbox) I would use a case like Select Case txttot.Value Case Is < 201 Me.ColourBox.BackColor = 255 Case 201 To 400 Me.ColourBox.BackColor = 38620 Case Is > 400 Me.ColourBox.BackColor = 65280 Case Else Me.ColourBox.BackColor = 16777215 End Select but don't forget...

I have been asked to write a report in a certain way, but I can't get my head around how to do it in access (or in SQL and pulling the table into access). I am open to suggestions even if I need to re-write the tables and how the data is imported. I have collected data that is in this format...