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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

i have a query in access with a con

Status
Not open for further replies.
access23

access23

Technical User
Jul 25, 2003
8
0
0
US
i have a query in access with a conditional iif statement goes like this iif([num]="1","y","n"). how can i make to display only the "n" in red color.
 
Sort by date Sort by votes
I don't know exactly how to use it, but I think you can use the Format() function
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JK Dutta
  • Locked
  • Question
requet for form an access query for report
Replies
2
Views
168
dhookom
dhookom
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
171
combo
combo
datajockey123
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
143
dhookom
dhookom
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
180
lameid
lameid
serino
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
297
serino
serino

Part and Inventory Search

Sponsor

Back
Top