can you please clarify? Thanks.

Could you please give me the query? did not understand quite right.

Black - when the numbers are in between for example the numbers should be in BLACK when it is less than A_NatlRate and greater than A_75NatlRate and when A_NatlRate ...

Starnge thing is happening, all turnig to BLACK!! after I apply the CASE statement.

Thanks so much!

I have figured out the problem. Please ignore. Thanks for your help.

it is not real data.

I have acually attached the data in the spread sheet.

I will have to figure out a measure

% of all meds with a doc on the day of the visit :

Question is how to write the code to figure...

Thanks.

I did that, but still having the " " for the three cols, is there any way I could omit them while importing data to a table?

Thanx

Thanks a lot! It worked.

It worked.Thanks a lot!

sorry, I am getting in this format, Jan 11 2006 12:00AM which is not right.

any idea?

Thanks a lot, it worked.