Recent content by Biscuit

Now why didn't I see that? Sigh!

I'm sure this has been asked before - but I'm a newbie. How do I say Thank You other than in the body of the message. I've been helped big time over the last couple of days. Is there a button? thanks

will do - all good:)

Is there a "Thank You" button anywhere? If so I'd press it. Thank you

:o Thanks a lot recyan. I built the queries and I got exactly the result I wanted. I'd have never got there by myself. You are a legend .:)

wow - thanks very much for putting so much effort into solving my problem. I've very grateful. I'll have a play with it over the next couple of days and see what happens. thanks so much :):)

Lets try this

hmm - lost the formatting

Don't know if this helps: Calculated Job # Worker Start time Duration end time 1 Fred 9:00 1.5 10.30 2 Fred 11:00 1 12.00 3 Fred 12:30 2 2.30 4 Fred 3:00 1 4.00 5.5...

Sorry - wasn't being specific enough. summing the total hours for the jobs is not a problem. I know if Fred has 5 jobs, each lasting an hour then the job total is 5 hours, and I ca get that for Harry and Dick as well. Trouble is, Fred gets paid from the time he starts his first job to the time...

I can attach the table design if there is a way to do that? Basically it's a roster which pulls up a client from a list, a worker from a list and then combines the two into a job. Because jobs are listed as "Archived"(they've bee rolled over or "Current" (i.e.not yet archived) I've combined the...

Thanks for taking the time to have a look at this. I've got fields in my query as follows: Date: Date Field Time: Med Time format Duration: recorded as # hours worked Minutes: [Duration]*60 ConvertMins: [Minutes]*0.000694 EndTime: ([time]+[Convertmins]+0.000694) So for each record...

Hi everyone. First time here so excuse anything that looks a bit stupid. I can't help that!!! I'm working on a summarized time-sheet based on a number of workers who do several jobs during the day. For example: Worker Fred sees client Jean at 9am for 2 hours. He then sees Joan at 11.30 for 1...