Date Query with formula

#1 January 11th, 2005, 09:27 AM

Hi All

I am creating a query which involves the use of dates and times. I have a
date in a table, which I am retrieving via the query. However in the query
I would like to use a similiar formula to that used in excel "WEEKDAY" to
return the day number based on the date eg Mon = 1, Sun = 7. Is it possible
to incorporate a formula such as this into a query?

Thanks

#2 January 11th, 2005, 01:39 PM

Check out the DatePart function in ACCESS. It will return a number to you
that corresponds to the day of the week, depending upon which day you decide
to call "Day 1" (you specifiy this as one of the arguments in the function).

--

Ken Snell
MS ACCESS MVP

"van" wrote in message
...
Hi All

I am creating a query which involves the use of dates and times. I have a
date in a table, which I am retrieving via the query. However in the
query
I would like to use a similiar formula to that used in excel "WEEKDAY" to
return the day number based on the date eg Mon = 1, Sun = 7. Is it
possible
to incorporate a formula such as this into a query?

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Financial Comparison	Steven Cheng	Setting Up & Running Reports	13	November 26th, 2004 10:59 PM
Still Hoping for help with a Query problem	Don Sealer	Using Forms	15	November 13th, 2004 06:24 AM
Union Query Not Returning A Value	Jeff G	Running & Setting Up Queries	2	October 19th, 2004 05:47 PM
Using Start Date and End Date in Query	ChuckW	Running & Setting Up Queries	5	July 20th, 2004 02:52 AM
Display Parameter from Form on Report	sara	Setting Up & Running Reports	10	July 19th, 2004 04:54 PM