Last Wednesday
Mar 7, 2008
Here is my current code:
FROM tbl_COMPANY INNER JOIN tbl_TESTS ON tbl_COMPANY.CompName = tbl_TESTS.CompName
WHERE (((tbl_TESTS.DateBilled)=#3/5/2008 7:15:02 AM#))
ORDER BY tbl_TESTS.CompName;
I no longer want to refrence the exact date and time. How can I change this to look at the most recent Wednesday? So if today is Friday it will look back 2 days, if today is Monday it will look back 5 days, if today is Wed it will look at today. I need it to find the most recent Wed.
We have an update Query that bills updates a Date field every Wed. I then update this query to pull a few reports. I think there is a better way to do this right? Thanks.
View Replies
Nov 14, 2005
This seems easy, but I can't get it right. I need to find the DATE of the THIRD Wednesday each month. (Actually, it is for a query criteria that will return TRUE if Now() is a "third Wednesday.") The problem is that depending on the month starting date, number of days in month prior etc. this date can be either in the 3rd or 4th week. Also, you can't just add 28 days to the prior month because it can vary.
View 5 Replies
View Related
Mar 13, 2007
dear all
how to calculate a date which is falls on every wednesday using ms access
for eg
this week enter date : 05/03/2007 and then save
next week automatically display date : 14/03/2007
later next time, enter date : 16/03/2007
next week automatically display date : 21/03/2007
i don't think this is the right formula
=DateAdd("d",7,[run_date])
if i keyin run date : 03/03/2007
it will display using above formula : 10/03/2007
but i want display run date : 07/03/2007 ( falls on wednesday )
what if keyin run date : 05/03/2007
it should be displayed : 07/03/2007 ( falls on wednesday )
any other way the right formula
thanks in advance
View 2 Replies
View Related
Sep 5, 2013
I have a report with a date field and want to sort it by week starting on Wednesday. I currently have the week starting on Sunday.
View 3 Replies
View Related
