Hello,
I am writing a report in MS Access 2000 where I have a linked table from an outlook inbox. The report is then run from a query using this table. The report lists FROM, SUBJECT, DATE RECEIVED (as DD/MM/YYYY HH:MM:SS) and DATE MODIFIED (as DD/MM/YYYY HH:MM:SS).
Basically what I have done is a function in an added text field which works out the time elapsed between Received & Modified as hours. The function I used for this is =DateDiff("h",[Received],[Modified]) which works great.
Now what I need is another text field that shows how many of these fields are >3...
I would apprecaite any assitance please.
Many thanks
Dklein
I am writing a report in MS Access 2000 where I have a linked table from an outlook inbox. The report is then run from a query using this table. The report lists FROM, SUBJECT, DATE RECEIVED (as DD/MM/YYYY HH:MM:SS) and DATE MODIFIED (as DD/MM/YYYY HH:MM:SS).
Basically what I have done is a function in an added text field which works out the time elapsed between Received & Modified as hours. The function I used for this is =DateDiff("h",[Received],[Modified]) which works great.
Now what I need is another text field that shows how many of these fields are >3...
I would apprecaite any assitance please.
Many thanks
Dklein
