Seperating Input Dates in Days of the Week....

[sedilson]

Okay

I have a Sign In form where the user selects their name from a combo box (cboEmployees) and then selects the project they worked also from a combo box (cboProjects) Then they entered the date they worked on that project by double clicking the Date textbox (txtDate) and selecting the date from a calendar form the txtdate is using the following format ddd", "mmm d", "yyyy which translates to Wed,May 21, 2003. Then the user proceds to enter the Sign In time (txtSignIn) and then the Sign out time (txtSignOut) then the time is calculated and put into a text box (txtTotalHrs).
All that specific information is stored under their specific fields in a table called tblSignIn.

Now i would like to generate a report that will allow me to seperate hours worked for the specific project for each day of the week.


Sample Report
-----------------------------------------------------------
Vendor Name Contract #

Location Defect Issue

Week (Mon - Sun) Part #

Shift

-----------------------------------------------------------
Employee Name Mon Tues Wed Thurs Fri Sat Sun Total
Hours


All the information from this report will be based on what the users enter on the SignIn form

How can i do this???

 

[sedilson]

Can Somebody help me with this i'm stuck.

Thanks

 

[sedilson]

HELP ANYBODY!

 

[WildHare]

There is a function which returns the WEEKDAY (hint hint) for any specific DATE, eg today would return 4 - the Fourth day of the week, Sunday being 1, Monday 2, etc.

So doing a query, grouping by the WEEKDAY (hint hint) of your date field, and then summing your HOURS guy should get you started...




Jim



Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare.htm

 

[sedilson]

What is that function called because i cant seem to find it

 

[WildHare]

Weekday

Weekday({dateguy}) returns the day of the week, 1 through 7 of the dateguy field.

Didn't you get the HINT???



Jim

Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare.htm

 

[sedilson]

Can Somebody please help me out or show me an example, in not very good with access and just need a good example to get me going....

I know the weekday function might work this but i just dont know how to get started.

This my SignIn Form

cboWorkWeek
---------------
May 5 2003 - May 11 2003
May 12 2003 - May 19 2003
May 20 2003 - May 28 2003
Etc

cboEmployeeName cboJobTitle
--------------- -----------
Jordan Supervisor
Iverson Manager
Carter Senior Quality Inspector

cboContractName txtDate txtTotalHrs
---------------- ------- -----------
General Motors
Blackhawk
Yahoo


Now based on this information i would like to generate following report

Sample Report
-----------------------------------------------------------
Vendor Name Contract #

Location Defect Issue

Week (Mon - Sun) Part #

Shift

-----------------------------------------------------------
Job Title EmployeeName Mon Tue Wed Thu Fri Sat Sun ttlHrs


Now Based on the date the user enters in the txtDate field i would like to split it up into the different days of the week.

Please somebody show me an example