calculation based on query

's Computer Specifications

I have written a query that displays start dates and completion dates for
jobs specific to one customer. I would then like to calculate the interval in
weeks in between the end of the last job and the start of the next, so that I
can draw a graph displaying this data.
How would I calculate the interval?
Thanks

's Computer Specifications

Try DateDiff("ww",Startdate,Enddate)

"Accessidiot" wrote:

> I have written a query that displays start dates and completion dates for
> jobs specific to one customer. I would then like to calculate the interval in
> weeks in between the end of the last job and the start of the next, so that I
> can draw a graph displaying this data.
> How would I calculate the interval?
> Thanks

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Query to change record based on calculation	Sabosis	Microsoft Access Queries	3	6th Jan 2009 11:38 PM
sum calculation in subform based off of a query	=?Utf-8?B?YmFicw==?=	Microsoft Access Form Coding	0	8th Jul 2007 03:46 PM
QUERY CALCULATION BASED ON DATE RANGE?	Liam.M@awamarine.com.au	Microsoft Access Queries	4	13th Aug 2006 10:49 PM
Query based on calculation	=?Utf-8?B?TmljaG9sYXMgS29ybWFuaWs=?=	Microsoft Access Queries	7	15th Nov 2005 06:58 PM
query field based on form calculation	Bart	Microsoft Access Queries	5	16th Dec 2003 10:51 PM