Help on getting a result in a report

From: SFCSCOTT <ssgheeren_1999@xxxxxxxxx>
Date: Mon, 28 Jul 2008 20:04:40 -0700 (PDT)

I have a query built that figures percentage. I want my report to
print out P1 if between 90 and 100 percent, or P2 if between 89 and 80
percent, or P3 if between 80 and lower. I get a compile error on this
VB code. Percent available is the Field Name from the query. What am
I doing wrong? Please help!

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Select Case Percent Available
Case " ", ">=90%"
Let [Text5] = "P1"
Case ">80%<90"
Let [Text5] = "P2"
Case Else
Let [Text5] = "P3"
End If
End Sub
.

Follow-Ups:
- Re: Help on getting a result in a report
  - From: Allen Browne

Prev by Date: Re: change recordsource of subreport?
Next by Date: Re: Help on getting a result in a report
Previous by thread: Re: MS Access 2003 Report to HTML supress natural page breaks
Next by thread: Re: Help on getting a result in a report
Index(es):
- Date
- Thread

Relevant Pages

Excluding data
... i have table and a query built .. ... now Im trying to run a report that ... excludes a field based on a number eg 3 = cancelled order so i dont want to ... ive tried with no luck ...
(microsoft.public.access.reports)
Excluding data
... Criteria 3 ... >i have table and a query built .. ... order so i dont want to ...
(microsoft.public.access.reports)