A Real Time Report?

[claing]

I've been asked to compile a weekly report from my Access system tha
would show a record with an OPEN date and CLOSE date
However, they are asking me to show the Close date and then after sa
a 3 or 5 day period the closed record would disappear from th
report. :x

Sort of a Real Time scenario. :?

Makes sense. :?

 

[Allen Browne]

Create a query into your table.

In the Criteria row under the Closed date field, enter:
Is Null OR >= Date() - 3

The query will show records where the Closed date is blank, or is in the
last 3 days. Use the query as the source for your report.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...