954,600 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Need to Display Number with an Asterisk

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!

bevssi
Newbie Poster
8 posts since Dec 2009
Reputation Points: 10
Solved Threads: 0
 
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>
ArtistScope
Junior Poster
150 posts since Jun 2010
Reputation Points: 5
Solved Threads: 14
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You