i suppose this is a pretty simple thing, i am unsure how to proceed though.
i have 2 recordsets counting items ifrom 2 tables how would i then add these recordsets together.
the recordsets ive used are shown below
Expand|Select|Wrap|Line Numbers
- set rs1=cn.execute ("Select count(*) as cardifarrivals from tbl_flight_details WHERE arriving_airport ='cardiff'")
- set rs=cn.execute ("Select count(*) as cardiffdepartures from tbl_flight_depts")
or is it possible to select count on 2 tables, and store this in another recordset?