query to show records before current date

[abbazabba]

Hi there everyone...

I have a database for logging the signing out of kit. One of the fields is 'Date due back'. At the moment I can find out what is due back each morning by doing a query for items due back that particular day.

What I would like to do is a query that will show records that are overdue.
So I need a query that will show records due back before the current date.

I'm sure it's possible but i'm stuck!

Cheers

Phil.

 

[markgrizzle]

in your query filter the due back date field with < date(). Using the date() function will always limit the query to dates older than the current date.

 

[abbazabba]

Thanks alot! That's just what I was looking for.

So glad I found this site!

Cheers.

Phil.