filtering records in a query

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

If I'm running a query that calculates the time elapsed
between a start and an end date, how can I filter the data
so that the query only pulls those records that actually
have an end date?
 
Alex,
Have you tried Is Not Null as the criteria for your EndDate column?
That should do it...
 
Back
Top