I have created bookings.asp which should list all albums booked out. How do I get and list albums which is Status = "OUT"?<BR><BR>
Are you refering to a Select statement ? If so then<BR><BR>SELECT * from TABLENAME where STATUS="OUT"
<BR>I got it working with ...<BR><BR>SQL = "SELECT * from tblCDs WHERE Status='Out' ORDER BY Artist, Yr desc, Album"