Search results

Hi, I wonder if anyone could help - I have a personnel form, with a subform showing absence. In my subform, I have a lookup box that displays the type of absence e.g. sl for sick leave, al for annual leave etc. On my main form I have a field called holiday entitlement per annum, which is...

I am a new user of Access, and basically trying to teach myself to set up a database for employees' detail, annual leave and sickness episodes. I have an employee and an absence table and would like to run a query to flag up more than 4 episodes of sickness in a given timescale. My absence...

Hi, I am very new to Access, and I have been asked to create a staff database for work. So far, I have my employee table, with names, addresses, job titles etc, an absence table for noting sickness episodes, ( I have entered fields employee ID (linked to employee table), absence type (lookup...

Hi, I am new to the forum and Access, and have the task of creating a database for the employees at work. I have my table of personnel set up, and a form to enter their data, which includes Employee ID, Title (lookup table), name, surname, address 1, 2, 3, town, county, postcode, Home, work and...