|
| 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
December 10th, 2004, 07:49 PM
|
|||
|
|||
week
Hi. I have an access 2000 table named payments and would like to select all records in which the date in field payment_date falls
within the current week. I would much appreciate any help as I have never worked with weeks in a query before. SELECT * FROM payments WHERE payment_date = DATE(ww) is this correct thanks a bunch for your help! 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Week Number is incorrect for January 2005 - shows as Week 2 | Cheryl | Running & Setting Up Queries | 5 | November 9th, 2004 05:11 PM |
| Grouping by date - How To: Show the first day of the week instead of the first date entered in that week... | Neil | Setting Up & Running Reports | 4 | October 8th, 2004 10:56 AM |
| Convert date into week number | Frank van Thiel | Worksheet Functions | 3 | July 6th, 2004 12:23 PM |
| Week number problem | Mike Collard | Running & Setting Up Queries | 2 | June 2nd, 2004 07:38 PM |
| Returning a date based on weeknumber | Jesper | Worksheet Functions | 10 | December 21st, 2003 04:25 PM |
Linear Mode
