Report based on records updated today 1

[encode]

Hi all,

I am currently working on a 'Daily report'. When a record is updated using a form, the date it was changed is added to the record. That part works fine.
The difficulty arises when trying to do a report. The sql query I had been using uses the where statement to filter by date, as shown:
WHERE (((tblPersonalDetails.LastUpdated)=Date()))

On Windows 98, this works great. But on Nt 4 workstation, it doesn't work at all - an error message appears, stating that the function is not available in expressions in query expression.

Does anyone have any ideas to work around this problem?
Thanks.

 

[scriverb]

Check to see if the same library references are being used on both type of workstations. There may be something different/missing in the NT workstation.

Get with me if you need assistance with how to do this. Bob Scriver

 

[encode]

Thanks!!!

I checked, and the CDO reference was missing on the NT workstation - it works fine now...