darksniper
10-24-2005, 09:02 PM
I have a report that contains game and its rating, the rating goes from -10 to +10, I would like to highlight the games that have a rating 1 or more with green color, rating 0 with yellow, and -1...-10 with red color, allso I would like to make a link on the game, so that when I click on it, it will open a form where that game is registered, for example it I want to change rating.
Smart
10-25-2005, 12:53 AM
I assume the fiekds in question are number fields
in your report design highlight the rating field
select format from the menu then conditional formatting
Under condition ensure the rating field selected
choose greater than from the drop down list
in the next field type 0
select forecolour (in this case green)
Click add
same field selected
choose equal to from the drop down list
in the next field type 0
select forecolour (in this case yellow)
Click add
same field selected
choose less than from the drop down list
in the next field type 0
select forecolour (in this case red)
I don't think you can click on a link in a report to open a form (if I am wrong I'm sure some one will let me know)
Reports are not interactive, a hyperlink on them would serve no purpose
darksniper
10-26-2005, 08:51 PM
is there another way I can make so that I could have links, because in design view it allows you to add a hyper link, but I could not connect to it a form, and it allso doesnt allow me to click on it.