RSmithwvsf
IS-IT--Management
i need to create a view to comapare data from two different tables
tbl1, will show r.id, fname,lname,admit,ftype
tbl2 will show p.id,p.date
now i need to see only recors where tbl1.admit=1 and tbl1.ftype = 'il'and where tbl2.date={?Date}and tbl2.id<>tbl1.id
pluse the date feild is a numaric feild and mus be coverted in the view to a date feild that can be entered by a user running crystal reports
any ideas
tbl1, will show r.id, fname,lname,admit,ftype
tbl2 will show p.id,p.date
now i need to see only recors where tbl1.admit=1 and tbl1.ftype = 'il'and where tbl2.date={?Date}and tbl2.id<>tbl1.id
pluse the date feild is a numaric feild and mus be coverted in the view to a date feild that can be entered by a user running crystal reports
any ideas