RS which uses more than one filter

Hi

I need to create a record set that checks to see wheter the value of a field is equal to a particular value AND unique reference number is equal to a session variable.

Any ideas?

Thanks

Matt

When you are creating your recordset, choose the Advanced mode. Here you will be able to defince your variables and create the SQL statement yo need.