After a lot of searching and trying I put my question here:

I have 2 tables (data1108 & data1208)
both tables have the same fields: date(text), amount(number) and type(number)

Now I want to have all records with the following criteria:

Date must be between date1 and date2, amount must be 5 and type must be 3.

The SQL for 1 table looks like this:
"SELECT * FROM data1108 WHERE amount = 5 AND type = 3 AND CLng(cdate(date)) BETWEEN CLng(CDate(date1)) AND CLng(CDate(date2))"

This works nice but now I want this from the 2 tables...which I can not figure out.

Help would be highly appreciated!