Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem working with asterisks

Status
Not open for further replies.
mhdragon17

mhdragon17

Technical User
Joined
Apr 11, 2005
Messages
5
Location
US
this is more a visual studio question, but i figured someone would be able to answer it...
what is wrong with this
=IIF ( Fields!AttendanceCode.Value = "\*" OR Fields!AttendanceCode.Value = "P", "Normal", "Bold")

Somebody decided to use an asterisk in the database to make it a little more difficult to work with, and my report still shows it to be bold. Am i doing the syntax wrong?
 
Sort by date Sort by votes
oh yeah ive tried to put them in brackets and that didnt work
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question Question
Working Days giving NULL values
Replies
8
Views
922
Cpreston
Cpreston
gussy81
  • Locked
  • Question Question
Decimal Datatype with negative value
Replies
5
Views
2K
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question Question
Update with a month name
Replies
9
Views
1K
gmmastros
gmmastros
TheBugSlayer
  • Locked
  • Question Question
Transaction with SELECT and UPDATE with XLOCK causing deadlocks
Replies
10
Views
1K
gmmastros
gmmastros
Billz66
  • Locked
  • Question Question
need to udate table entry with number containing a *
Replies
11
Views
850
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top