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

Reply to this topic