Need help on report for school

[Johnhook]

I am making a database for my school project. It is a databse to record items in a warehouse. I need a report that shows all items currently in the warehouse. I have a field called date to be removed. I need to basicaly make a report that shows all records in which todays date is less than date to be removd.

I have completely drawn a blank and cnat think of any way of doing this.

Please help me

Thanks
Jon

 

[yellow]

You need a query based on your table. In the criteria of the [Date To Be Removed] field put >Date()

This should give you all records where the [Date To Be Removed] field is greater than todays date.

Then base your report on this query.

Hope this helps.