Help With Filtering Question

[cvegas]

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.

 

[Mark via AccessMonster.com]

Try
Me.Filter = "((Shipment.PUDate)=Date()) OR (Shipment.SchedDelDate)=Date())"
Me.FilterOn = True

Sometimes I have to play with the parenthesis by either adding or substracting one level.

 

[John Vinson]

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.

Eh?

How about

Me.Filter = "(((Shipment.PUDate)=Date()) OR
((Shipment.SchedDelDate)=Date()))"


John W. Vinson[MVP]