Search results

not sure how i'd do it by day! i just have a single query on the hourly wage column of my tblEmployee which returns a single value say £7 this query is then combined with another query so i can tie in the avg wage to compute my daily figures could you suggest how i would do this on a daily...

why would it? my hourly wage is coming from my employee table, it's used in a query for my finances. so when i bring up the query to show all the finances it will update the avg salary everyday! you post doesn't make sense dude!

i have a tblemployee with hourly wage in. i have a query which takes the Avg of all these wages. This is used for my employee rota DB to work out labour % at the end of the night. so this looks at cost of labour against gross profits. However i've just relised a flaw... Say on monday my Avg...

struggling with this one. I have a DB for a restaurant, and a report i have shows all the labour %'s for each day. i want the form to total all these labour% up and give an average labour % for the week. but it aint happening!! keeps coming up with stuff like 2123.00%!! I have created a...

Access help do a search on criteria and pick 'Enter criteria to affect when calculations are performed' that will explain the lines I was thinking about. You should be able to work it out from there. had a look here mate but not sure thats what i'm after, or at least i couldn't work it out...

Have a table called tblshift with empid and tblshift as compound_PK and have attributes at starttime and finish time. so i can set an employee to work any date and any start and time within that date. i want to implement another table which i've called tblavailability and has the same...

Ok: I've managed to get the dayofshift from the tblavailability into my query for the rotas which contains the information from tblshift. so i have tblavailability.dayofshift and then in the next column tblshift.dayofshift and all the other columns but i guess there not too important for this...

Ok.... you won't belive it but i'm really getting somewhere now i'll post it later and let you see!! i WILL BE FINISHED FOR TOMMOROW!! it's looking sweet - got action querys to update and append records i'm quite proud. anyway parker: I've compacted, copied and created new table it's called...

I'm almost done with a db ive been designing to store information for a restaurant. i have a prob and can't think of solution... but it's prob easy!! I have a shifts table which records the dates and shifts that employees are going to work this takes the format of Employee Name, Shiftdate...

Sorted that just took the text box with the code in, made another text box found number of first text box eg text17 and used this code: =[Text17]+7 voila! :D

For example: how could i modify it to show the sunday after the monday? so i'd have next monday date: 10/07/04 next sunday date 17/07/04

Yeah as soon as i sent it i worked out prob! needed to save form for it to take effect! works a treat! how does it work though? just so i know and i've not just copied it off ya

That doesn't seem to work :confused: do i need to change it or is that just what i need to enter for the source?

i'd like to show in a text box on a form the date for the next monday available so say today is 7/7/05 id like it to work out the next monday which is 10/7/05 and put this date into the text box?! any ideas??

I've worked it out!! (in case anybody cares) all i needed to do was create a new query, put in the dates and the total mins for each employee then as the total for the total mins set this as SUM voila :D

(look at jpeg!) So i've got total mins worked which can be formated into hours/mins later. i need to work out the total mins for one date eg 07/05/2004 this would be i think it's 480+240 or whatever. anyway - i can't find a way of adding these totals together please advise! :eek:

Sorry Parker - i keep getting confused The time worked is the information from calculating the rosta. to change the time worked i would need to change the rosta. so these will have the same information -- why would i need to record the same information twice?

Employees don't work double shifts, if there were to work say day shift and night shift then the start would be say 09:00 and finish would be 23:00. but this is a rare occurence as for changing the shifts, if an employee doesn't work this shift then the user can delete that record of them...

if i ran a query to find everyone who worked on say 6/05/2004 it would show all their names and start/finish times. i was thinking of just setting up a form to allow user to change finish time to incorperate any 'overtime' its for a restarant, and luckly they never ever work after 23:00 so thus...

for your next trick: take a look at jpeg, it's the warning box that displays this information saying the primary key blah blah it's confusing, and the user won't have a clue what that means how can i get this to read something like "You already have that employee working on that day" Cheers