Search results

Thanks Ranman i will give this a go. When you say i dont care the days though, what do you mean? Because once the data comes out i need to calculate the working days (Monday - Friday) between the periods. Or i could maybe do this before and total the working days field? Thanks again Chris

Hi all, I have a table with dates of sickness for employees. However no 'one' record can cross over into the following month like 25/01/2016 - 05/02/2016. So they are recorded to the end of the month then a new record starts from 1st of the following month. Example: If an employee had records...

Thank you for explaining, I have changed it now :)

Hi all, I have been asked to provide a report of what Position/Job each employee was doing on a set date. The data in the table is in the layout as below. I am struggling on how i would get the report. Example - what was each employee doing on 01/07/2015 EmpID 1 was a Team Leader EmpID 2...

Hi arnelgp, This seems to work as we wanted! Thank you very much for you help :) Hi Galaxiom, Does the 'order by' do anything to help this work? As you can see above it seems to be working, but dont want it to fail at a later date like you mentioned.

No there is no time, im confused.. So close to getting it :(

Thanks plog, I tried this but the end date is the same as the start date of current record. End Date: DMin("StartDate","Employees","[EmpID]='" & [EmpID] & "' and [StartDate]>#" & [StartDate] & "#") Any ideas?

plog that seems to have worked. I have all the basics DMin("StartDate", "Employees", "[EmpID]='" & [EmpID] & "'") At the minute it just pulls out the smallest date of all records. How do I get the "smallest date that is larger than the existing record with the same EmpID" Thank you for your...

Thanks plog, this would make sense. The end date would be the returned date minus 1 day. However i am struggling :( In the example on the webpage this is where the employee number = "10248" how would I say where the employee number = the employee number of current record? Hi arnelgp, I have...

Im sorry... let me try give an example Record 1 - Employee 1 Emp ID = 1 Start Date = 01/01/2015 Description = Admin Record 1 would look at record 2 for this employee and determine the end date is 30/04/2015 (day before start date of record 2) Record 2 - Employee 1 Emp ID = 1 Start Date =...

Hi all, I have a table containing records for employees..each record contains a start date but no end date The first field is employee number, then the other fields are the record data.. For each record I need an end date which will be the day before the start date of the next record as long...

Hi Minty, This is something we want to do (write these in SQL), but at the minute we do not have the privileges/permissions. All we can do at the minute is view existing tables which we link into access then make the queries. Hopefully our IT department will authorise us to do the above...

THank you both for your replies. Sorry about the delay i had finished work when you replied. Yes there are a few iif statements, these are the queries that seem to take a while and are probably the cause of the slowness. Sorry Minty, im not sure what you mean. The queries in this project are...

Hi all, I have a query that takes around 10-20 seconds to produce due to all the queries that run before it. This data is displayed within a form I have created. However the problem is that it runs the query each time the form is opened. What I have done is put in an 'Update' button that will...

Thanks Guys, I included the dates in the join as suggested by Brianwarnock and I have checked a couple manually and it seems to be working :) Thanks again. Brianwarnock what do you mean with the Count, will this help me?

Hi all, I have the following query to get the most recent record for each person. SELECT DET_NUMBERA, Max(SUP_START_DTC) AS [Start Date] FROM CHRISCS_EMSUP GROUP BY DET_NUMBERA; However I need it to pull out multiple records if the SUP_START_DTC is the same for the person because people can...

Thanks for your reply. Think I have fixed this part now, but when i make my selection the subform does not show the new data...does the subform need refreshing?

Hi CJ_London, Trying it your way an i have everything setup as instructed. However when i make a selection from the combobox I get an error - Microsoft cannot find the object 'sfqueryview' I have double checked that the subform is named sfQueryView. Cannot think of what else it could be.

In that case im going to give it a go :rolleyes:

Thank you both for your replies. I think your way might be a little to complicated for me CJ_London haha. Minty just tried yours and managed to get it to list the queries in the listbox. Now I just need to find the code for Excel. This has definitely set me off in the right direction...