Timesheet Database 1

[perrymans]

So how would I do a timesheet database?

If the form looks like:

Day         Annual Lv   Sick Lv   StartTime  EndTime

Sunday
Monday          8
Tuesday                             0730       1700
Wednesday                           0730       1700
Thursday                            0730       1700
Friday                              0730       1700
Saturday

Would this just have to be a giant DLookup to the tables? Or is there some easy way to accomplish this that I am not seeing?

Thanks. Sean.

 

[stix4t2]

Perrymans,

This kind of stuff is usually done with a cross-tab query. By creating a query you, Access will build the table

Day Heading Val
GrpBy GrpBy Sum or First
row col val

 

[lars7]

Hi,
I was coming to start a new thread when I saw this one and It's almost what I'm Looking for. I would like to build a record over time of staff activity but since the information is held in different tables the queries I have tried will not let me write to them. Is there any good examples of this kind of database out there as I'm struggling at the first hurdle. Here is an example of what i would like to have recorded on a weekly basis, the staff here would be grouped by a location. Sorry Perrymans for butting in.


EmployeeName Annual Lv Sick Lv ect
LYNN,MARGARET 8
MEEK,AGNES
WATSON,ADA 5
RUSSELL,LESLEY
HUGHES,JANICE
CAMPBELL,MORAG
MCCALLUM,ISHBEL 10
CAMPBELL,HILARY

 

[stix4t2]

lars,

What I was describing was for reporting information back out. You describe wanting to input information. In your case I would create a subform at the top that allows you to display the information, using a cross tab query. Then below the subform I would use and entry form for updating and adding information. You can use the click event on the subform to select values in your entry form. Based upon your description, you may also want to make the entry a subform. Why you may ask, because the click event could also be used to set the subform to various entry forms for the various tables.

 

[PHV]

the information is held in different tables the queries I have tried will not let me write to them
Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lars7]

Thanks Phv,
I got good information from your link. Sorry Stix4t2 for confusing the original post with my enquiry and thanks I am trying out your suggestion now.

 

[stix4t2]

lars,
No problem, I just wanted you to know the nature of the original advice.