i have three SQL statements, i want to show the results of these three statements one after another, for that how should i use "while statement". i have tried in following ways, but nothing works properly:<BR><BR>"while not rscat.EOF and rscat1.EOF"<BR>"while not rscat.EOF and not rscat1.EOF"<BR>etc., please suggest me the right way to do it.<BR>Thanks<BR>