应该改为:Sandy was ill in bed yesterday.
in bed“(卧病)在床上”,或在“在床上(睡觉)”,如be ill in bed“卧病在床,其他一般性“在床上”,一般用on the bed