Search results

Good Sunday to every one, I have a query that calculated the working hours and assigns a multiplier according the day (Sunday/Public Holiday), overtime etc.. in one of the fields I have an expression with a select case statement: PayHours: Switch(((Weekday([EventDate])=1) And...

Hi to everyone! I have a subform in datasheet view, based from a query which is a collection of events data during the years. I wanted to apply conditional formatting to highlight the Public Holidays. I have a table [tblPublicHolidays] listing the relevant public holidays dates throughout a...

Good day to everyone I have a data base for managing employee’s attendance and work hours, vacation leave etc... it started a very simple application keeping records of attendance in time it complicated itself quite a bit. One major issue that I’ve been struggling around is when one of the...

Hi to everyone I'm a bit confused :confused:a friend of mine asked me to help him out on a project he is doing. He want his users to input on a daily bases the appointments of various clients, for record and statistics. I created two tables one DailyVisits (ID & Date fields) and the other...

Hi I have a problem (which in excel can be done very easily) in a query. I have a query which selects the vacation leave hours taken by each employee. I need to add a calculated field to be able to subtract the hours taken on the date from the amount available for that year. e.g. date...

Hi to all I'm new to this forum, I've been using Access for the last four year when I upgraded my data from excel. I have a couple of databases at my place of work and I'm always updating and improving them to meet the users requirements, which sometimes go beyond my skills and knowledge...