[AccessD] Really simple date question

John,

You could probably do in it a query.  Assuming that Sunday is your ending
day ...

SELECT DateAdd("d",-6,[dp]) AS Mon, 
	DateAdd("d",-5,[dp]) AS Tues, 
	DateAdd("d",-4,[dp]) AS Wed, 
	DateAdd("d",-3,[dp]) AS Thu, 
	DateAdd("d",-2,[dp]) AS Fri, 
	DateAdd("d",-1,[dp]) AS Sat, 
	[dp] AS Sun;

[dp] is the parameter used to pass in the date to the query.

Bobby


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: Monday, August 28, 2006 4:34 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Really simple date question


hello

I am revisiting a little timesheet program that I want to make for the
office. I want to enter a "week ending" date, at the top, and have it
fill in dates for the previous six days. So, if I enter 09/02/2006 for
this week's ending date, I want to fill in a label, text box, etc. for
Sun as 08/27/06, and Mon 08/28/06, and on through Saturday, which would
be the same as the ending date.

I then want to enter start time and end time, and also lunch times, and
come up w/a total.

As usual, I thought this was going to be simple, and I can do it in a
query, but in the form I am getting "mismatched types."