Exclude

I have a database from which I have to produce weekly reports excluding
previous week report. Below is an example how the reprt should look like.

Logged Date Recieved Date Completed Dated 415 Current Status
2008/08/01 2008/08/10 2008/08/20 Cancelled

(only Cancelled or Completed here)


how can I only exclcude previous weeks report weekly per completed/cancelled
(pending on the 415 Current Status) system date (meaninig per the date in the
computer when I punched Cancelled or Completed under 415 Current Status)?

--
Message posted via http://www.accessmonster.com

I don't fully understand ....but:

to exclude results based upon date, put in the criteria of your query for
the appropriate field: 8/4/08
(using today's date as an example)

obviously put in the appropriate date to segregate "this week" from "last
week"...and you might need to get creative as to whether this date is entered
manually or auto entered based upon perhaps the computer's system date...

--
NTC


"earrozz via AccessMonster.com" wrote:

I have a database from which I have to produce weekly reports excluding
previous week report. Below is an example how the reprt should look like.

Logged Date Recieved Date Completed Dated 415 Current Status
2008/08/01 2008/08/10 2008/08/20 Cancelled

(only Cancelled or Completed here)


how can I only exclcude previous weeks report weekly per completed/cancelled
(pending on the 415 Current Status) system date (meaninig per the date in the
computer when I punched Cancelled or Completed under 415 Current Status)?

--
Message posted via http://www.accessmonster.com