Member Avatar for bevssi

I need some quick help, Please! This is probably very simple but I'm making it hard. My code displays 2 totals for a month, this year and last year. But, if the month's record doesn't exist it picks up the year's start total for which I have a simple If statement.

I need it to display an asterisk next to the number if the year's start total is picked up. Is that a Cast?

If isNull(mem09) Then
mem09=pyrstartmem
End If

<tr align="center"><td class="td3" ><%=(church)%></td><td class="td3"><%=(mem09)%></td><td class="td3"><%=(mem10)%><td class="td3" colspan="13" align="center">No report submitted for <%=(moname)%></td></tr><%

Explanation: this code displays 2009's January membership number, say 575 (mem09)

but if there is no record for January, it displays the year's beginning number, say 580 (pyrstartmem)

If it is displaying 580 I need it to say 580*

Can anyone help? Thanks so much!

  • 2 Contributors
  • 1 Reply
  • 126 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by ArtistScope
Member Avatar for ArtistScope 
If isNull(mem09) Then
mem09 = pyrstartmem & "*"
End If

<tr align="center">
<td class="td3" ><%=(church)%></td>
<td class="td3"><%=(mem09)%></td>
<td class="td3"><%=(mem10)%></td>
</tr>
Edited by ArtistScope because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.