Search results for query: *

Expr1: IIf([ST]="01","y",Format("n","[red]")) Can anyone tell me why this is not work? I want to change the "n" to red color

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.

Hello, WildHare No problem. Whenever you have time. thanks!

yes

To GingerR (MIS) I tried and it's worked. the only problem is i have over 10,000 records to go through. It's great to know the trick. Thanks alot.

To WildHare (MIS) Can you tell me how to run update queries to populate the others fields base on name match? Please thanks,

Thank for the tip, i tried the crosstab query but it did not give me the result as i want above. Do you have any other suggestions? new to access

i have a table contain customer name and address like this: name address john doe street john doe city john doe state john doe zip how do i make the table look like this: name address1 address2 address3 ... john doe street...