Search results

I posting this question last week and no one responded! I can use this function (conditional formatting) correctly in the details section of my report, however it doesn't seem to work correctly with the footers. My footer sums my data from the detail level and also takes the percent change...

Conditional format function I can't be the only person who has ever had this question! Anyone take a guess?!

Conditional formating help. Anyone?! Is anyone out there? I am curious if anyone else ran into this problem?

I have just upgraded to Access 2000 and have been playing with the conditional formating function. I like it a lot. I can use this function correctly in the details section of my report, however it doesn't seem to work correctly with the footers. My footer is basically summing my detail and...

Not quite there! I'm not sure of your last advice. Here's what I got so far... Private Sub Report_Open(Cancel As Integer) Select Case Me.PQR Case Is > 0.05 Me.PQR Then Me.PQR.FontBold = True Me.PQR.FontSize = 10 Me.PQR.FontName = "Copperplate Gothic Bold" Me.PQR.BackColor = 12632256 Case...

Changing the format code I can't quite get it to work. It is getting stuck at the line Me.PQR > 0.05 Then The ">" sign seems to be a problem. P.S. I don't know if it matters, but I have Access 97. (maybe someday my organization might update our software) Thanks!

I have a huge report that calculates the percent change over the previous quarters in the detail and footer sections of my report. My VP wants to scan the 20+ page report and easily find significant changes. Question: Is there a way to highlight the changes that are >5% or <5% with a...

There is probably a simple answer to this question. I can't get a particular statement to work in the header that works in the footer. =[MSA] &" Region" When I preview this statement from the header in reports I see "#Error." Yet this same statement works in the footer. Any thoughts...

Not the answer I was looking for Thanks for attempting an answer, but I don't think that will work. Why? In the report, doesn't the zero turn into a 0%? When in actuality it shouldn't be a 0%. I had previously tried an IIF criteria in the design view of the report, but since "-" is not a...

I am sure there is a quick fix for this. I am building a report that uses a query. The query performs simple calcuations like percent change. There are a few rows in this query that are dividing by 0, so the result is "#error". What is a simple expression I can write in the report design...

Almost there-running sum in query by pl Jon and Pat, Thanks for taking the time to help out. I am close to getting Pat's SQL statement to work, but I can't get it to total correctly. Here is a small sample of my results. It correctly starts the total over after a new product line and/or...

Running sum by product line I am a novice programmer, could you help me write this compound dsum() function? I want to create a running total for [% of fy2003 total admissions] by [product line] by [hospital]. The name of the table is "The Ranking." The table lists the [Rank] for each...

I've seen Microsoft's method to create a running total using a query, however their method creates a running total for the whole table. I have a table that ranks top physicians by hospital by product line. This is a large table because our organization owns several hospitals. The ranking is...