Search results

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...

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...

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...

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??

(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:

Take a look at the attachement which is a .bmp I need to make it so that shift links to employee, and an employee can only have one shift on a single day! but can't work this out. the way it is now an employee could end up with overlapping shifts on the same day!? please advise! :)

Novice Needs Help!!!! Agreed to do a project which i can't work out in my tiny pea sized mind how to do! ok here goes :confused: It's a database for a restarant. which i can do. however it's going to allow the user to create rotas/timetables for the employees. so... i want the DB to show...