i am making a database to include all hospital equipment. i have to make a report on all items that have to be returned in a week, ie, all item that have to be returned between today and 7 days from now, i cant find a way of putting this into a qeury, can anyone help? please reply here or e-mail me, thank you
sophie

Presume that you have a field called something like [Return_Date]. If so then in criteria type of Return_Date: Between Now() AND (Now() + 7)

HTH

Use the Date() function rather than Now() since you want date only not date and time.

thank you both, now working perfectly!!