Recent content by Mand

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

thanks - yes, everything seems complicated with this program! Your help is very much appreciated! x

Thank you...I had tried this, but when I ask it to show the episodes total AND the dates on the same query it all goes a bit awry...:confused: I get one employee with their dates and then the total of all episodes next to each date. Is there a way just to have one total per employee's dates...

Hi Sorry to trouble you again - I now have the query working - have re-done it all and used your method. I am just wondering how I get a 'total' column at the end? I want to add up all of the sickness absences in the date range I have chosen per employee and display it. e.g Mrs Sarah Rayner...

Sorry, I think I am beyond help! I ran this and it brings up the end episode column with the number one in each one - totalling 18 records, which is all of the sickness episodes I have entered - both ongoing and new. What I need is a query that will run and tell me what employees have had 4...

Thanks for your reply, sorry, if I am in the QBE grid and I have field name: New Table: Absence Table Where do I put the code that you entered? Thanks

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

Right, sorry! What I had done with the date was actually enter the date that I wanted rather than 'opening date' etc. I am very new to Access and am self-taught so far, so got a bit confused! I will try this again and see if this works! Thank you for your patience! I think this application...

I see what you have done now I think. Hmm, mine seemed to be working - is this wrong then? - it does seem to be pulling out the info I want; however I don't know how to set parameters like you have done with yours, which does seem handier if you want to change the date that is inputted...

hmm, I seemed to have a problem with this! In the end I ran query 1, then in query 2 referred to query 1 table and did Pesonnel ID: Group by Name - group by Surname - group by (added these in as I wanted to see the employee's name aswell) Absence type - "count" and in criteria box >=4 Absence...

I have followed the instructions, and have made the first query, but when I try the group query - it's not counting the emplyees with more than 4 occurrences - it's coming up with only one Emplyee ID and the number 6 in the count - although there are only 3 episodes of Absence for this person...

Thank you so much for your time and effort, I will have a crack at this and let you know how I get on!

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