Forums
This topic is locked
filter recordsets with views and tables
Posted 27 Jan 2004 23:38:16
1
has voted
27 Jan 2004 23:38:16 sander kerstens posted:
hi there,i think this is a simple question
i have a table in access with the following fields:
name:
height:
width:
format:
the height and width field are mulitplied with eachother and put in
a new field called:
myfield:
this is al done in access no asp yet
now i want to setup a recordset
SELECT *
FROM formaten
WHERE value > myfield
value is list a list of number which have to smaller than the myfield
value is a table field
myfield is a view field
how can i filter a recordset with a field that is to be found in the views at the
bottom of the recordset dialog box...
i hope i made myself clear......
thank in advance for the help
greetzzz Sander