Fitlering a Form - Urgent Help please :D

mavver

Registered User.
Local time
Today, 09:07
Joined
Jan 12, 2007
Messages
28
I am trying to filter a form on two things using the properties pop up box within the form design.

Initially I had it as just filtering on one thing and it worked fine

[InboxMerged]![Valid]=True

However I want to filter on two things now, the above and a date time stamp as below.

[InboxMerged]![Recieved]>8/31/2007 17:59:27

However it brings up problems with syntax and the like.

Can anyone help me, I need to get this done ASAP so any help is very gratefully recieved.

Mavver
 
Remember that date/Time needs to be enclosed by # characters.

so

[InboxMerged]![Recieved]>#8/31/2007 17:59:27#
 

Users who are viewing this thread

Back
Top Bottom