Help With Filtering Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
Click to expand...


Eh?

How about

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


John W. Vinson[MVP]
 
Back
Top