Date limited report

[ifoundgoldbug]

Greeting
I am trying to make a report that will only grab records that fit
pmdate <date()+7 AND pmdate >date()-1. basically I just want to make a
report of items for the upcoming week. Is this possible???

Thank you for your time

Gold Bug

 

[John Vinson]

Greeting
I am trying to make a report that will only grab records that fit
pmdate <date()+7 AND pmdate >date()-1. basically I just want to make a
report of items for the upcoming week. Is this possible???

Thank you for your time

Gold Bug

Sure. Base the Report on a Query with a criterion

= DateAdd("d", -1, Date()) AND < DateAdd("d", 7, Date())

on pmdate.

John W. Vinson[MVP]