Filtering Expression

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cvegas - 14 Jan 2005 18:41 GMT

SELECT Shipment.PUDate, Shipment.SchedDelDate
FROM Shipment
WHERE (((Shipment.PUDate)=Date()) OR ((Shipment.SchedDelDate)=Date()));

I would like to filter my frmDispatchBoard based on the query above.

I am having problem with the syntax.

Me.filter = ?????

Any help would be appreciated.

Reply to this Message

Allen Browne - 15 Jan 2005 03:46 GMT

The Filter string is just the WHERE clause form your SQL statement.

Try:
Dim strWhere As String
If Me.Dirty Then Me.Dirty = False 'Save first.
strWhere = "(PUDate = Date()) OR (SchedDelDate = Date())"
Me.Filter = strWhere
Me.FilterOn = True

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> SELECT Shipment.PUDate, Shipment.SchedDelDate
> FROM Shipment
[quoted text clipped - 7 lines]
>
> Any help would be appreciated.

Reply to this Message