If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Exclude
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 |
Thread Tools | |
Display Modes | |
|
|