P
Patrick
I have a table where for each record 2 filenames (including path) are stored.
I made a form witch shows the file date&time of the 2 files
<< ControlSource: =FileDateTime([filename1]) >>
and determines if filename2 is older than filename1.
<<ControlSource:
=IIf(FileDateTime([filename1])<=FileDateTime([filename2]);"Up to Date";"OUT
OF DATE!!!") >>
This works fine. The form shows all records showing if up to or out of date.
I cannot filter the form on this upto/outof-date field to show only
out-of-date records.
Can I make a query or filter witch only shows records that are "OUT OF
DATE!!!" ?
Thanks
I made a form witch shows the file date&time of the 2 files
<< ControlSource: =FileDateTime([filename1]) >>
and determines if filename2 is older than filename1.
<<ControlSource:
=IIf(FileDateTime([filename1])<=FileDateTime([filename2]);"Up to Date";"OUT
OF DATE!!!") >>
This works fine. The form shows all records showing if up to or out of date.
I cannot filter the form on this upto/outof-date field to show only
out-of-date records.
Can I make a query or filter witch only shows records that are "OUT OF
DATE!!!" ?
Thanks