sorry for such a silly question. its just that my If statement wont work. I thought id ask what you would do.
Set RS = some sql query<BR><BR>IF RS.EOF then<BR> 'no records<BR>else<BR> 'returned records<BR>end if
thats great. I was just drawing a blank and the guys at haneng.com couldnt help. <BR><BR>findel