Filtering info from a database

[Spike]

I'm trying to filter data from a database called "G63" to give a single
result based on two filtering criteria. The problem is I can only get the
result of one filter at a time, as shown in the code below...

function filterByTown(form) {
document.getElementById("table1").dataSrc="#G63"
var filterExpr1 =
form.filter1.options[form.filter1.selectedIndex].value;
var filterTown = "Town =" + filterExpr1;
G63.Filter = filterTown;
G63.Reset();
}

function filterByBusiness(form) {
document.getElementById("table1").dataSrc="#G63"
var filterExpr2 = form.input.value;
var filterBusiness = "Business Type ="+ filterExpr2;
G63.Filter = filterBusiness;
G63.Reset();
}

How can I get the resultant "G63" table to display the common results of
filterTown and filterBusiness together in the same table?

e.g. Say I want to display all the business types which are hotels, but only
occurring in the selected town of Richmond.
The above functions allow me to display all the businesses in Richmond, or
all the hotel businesses in all the towns, but not exclusively the hotels
only in Richmond.

Any help would be greatly appreciated. Thanks.

[Tim Williams]

Assuming you mean an ADO recordset, it does support more than one
criteria.

Eg:
G63.Filter = "SupplierID = 20 AND CategoryID = 1"

Tim.

"Spike" <mi*******@yahoo.co.uk> wrote in message
news:d3**********@news.wplus.net...

I'm trying to filter data from a database called "G63" to give a
single result based on two filtering criteria. The problem is I can
only get the result of one filter at a time, as shown in the code
below...

function filterByTown(form) {
document.getElementById("table1").dataSrc="#G63"
var filterExpr1 =
form.filter1.options[form.filter1.selectedIndex].value;
var filterTown = "Town =" + filterExpr1;
G63.Filter = filterTown;
G63.Reset();
}

function filterByBusiness(form) {
document.getElementById("table1").dataSrc="#G63"
var filterExpr2 = form.input.value;
var filterBusiness = "Business Type ="+ filterExpr2;
G63.Filter = filterBusiness;
G63.Reset();
}

How can I get the resultant "G63" table to display the common
results of filterTown and filterBusiness together in the same table?

e.g. Say I want to display all the business types which are hotels,
but only occurring in the selected town of Richmond.
The above functions allow me to display all the businesses in
Richmond, or all the hotel businesses in all the towns, but not
exclusively the hotels only in Richmond.

Any help would be greatly appreciated. Thanks.