[AccessD] Really simple date question

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Mon Aug 28 17:04:14 CDT 2006


John:

Bound form?  Do you want to add these records with the dates but without 
the times to a table?  Or unbound form where you  accumulate all the 
data on the form first and then write to the table?

Rocky


John Clark wrote:
> 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."
>   

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com




More information about the AccessD mailing list