Search results

Thanks David, My data when exported is in this format... Entry Date Project Hours Project Name 02/02/2009 7.25 Project A 02/02/2009 2 Project B 03/02/2009 2.5 Project A 03/02/2009 5.17 Project c 03/02/2009 1 Project D Etc Etc Etc...

I know I'm not explaining this well - I've only just got my head around it... Ok say I work a 10 hour day against a 7.5 hour contract across 4 projects Project A = 5 hrs Project B = 2 hrs Project C = 2 hrs Project D = 1 hr I need to calculate the total additional time (that's the easy bit) by...

Hi - yes this bit is working - my other post about discretionary time is still causign me problems and I need that one leaving open to see if anyone can help! But thank you ever so much for your help with this thread! :D

Hi, I have a query: SELECT qryProjectSelect.[Department Name] AS Department, Sum(qryProjectSelect.[Total Hrs]) AS [Total Hours], [Total Hours]/[Grand Total] AS Percentage FROM qryProjectSelect, qryProjectTotalHours WHERE (((qryProjectSelect.[Entry Date]) Between [forms]![frmQuery]![txtStart]...

I can't through this element... I have a query that calculates the time spent for named member of staff across a specified time frame by project per day: SELECT qryIndvSelect.[Entry Date], Sum(qryIndvSelect.[Total Hrs]) AS [Project Hours], qryIndvSelect.[Project Name] FROM qryIndvSelect WHERE...

I do remember the theory... but it's been several years since I used Access where I needed to link tables and develop relationships between my data... Still a bit rusty... but with my manager getting very excited about this database I think i'll be dusting off my long lost memory cells...

Ok... I've got a query that claculates all staff working days between two dates taking into account start and finish dates and also their FTE... SELECT tblStaff.[User Name], tblStaff.[Department Name], tblStaff.[User Start Date], tblStaff.[User End Date]...

Done it! SELECT fGetListVals2("frmQuery","lstDept",1) AS YourValList FROM tblDept GROUP BY fGetListVals2("frmQuery","lstDept",1); Sorted! Thank you ever so much - thought I was going crazy... Whereabout in S Yorkshire are you? i live in Doncaster but work in Sheffield...

Hi Leigh - thanks for that it works! I get all items selected in the listbox but repeated for all the lines in my tblDept... Is there a way I can not display those? Thanks again - feels so close!

HELP!!! I'm still really stuck with this - I've got a presentation to the whole company on Wednesday and I cannot work out for anything how to get the list of values out as one output in a query... :-(

Thank you so much! I've got the whole thing including part time working for individuals passing the query "QryWorkingDaysByEmployee" into another query and filtering where the staff name matches the text box on the frmQuery... I can't get the same query trying to look up the selected...

Thanks Leigh, I'm getting an error - I've saved the original function you kindly provided and am tryign to call it using this statement in my query... SELECT *, fGetListVals([Forms]![frmQuery]![lstDept], 1) As YourValList FROM tblDept; tblData is where all my data is but my list of...

I've also just been told that we are to recruit our first part time employee... I'm guessing I'll need to add a field to the tblStaff for FTE i.e. 0.8 for 4 days a week or something similar and somehow include that into these calculations? Thanks again for your time and support

Thanks David for your help and also Bob for your suggestion... For the returned database I am very grateful! :) One question: At present the new query "QryWorkingDaysByEmployee" is picking all employees from tblStaff. For my individual report I'll need it to just pick the person chosen from...

Private Sub cmdDeptReport_Click() Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim varItem As Variant Dim strCriteria As String Dim strSQL As String Set db = CurrentDb() Set qdf = db.QueryDefs("qryDeptSelect") For Each varItem In Me!lstDept.ItemsSelected strCriteria = strCriteria & ",'" &...

hope this helps...

Thank you ever so much for your help... I've used this wording but get an error: WorkingDays: CalcWkDays2(#01/01/2009#,#01/04/2009#,-1,"17",[User Start Date],Nz([User End Date],#01/04/2009#)) "The expression you entered has a function containing the wrong number of arguments." I'm trying to...

Hi, I've tried all possible searches both on this forum and on the wider web... So apologies if anyone can point a way of wording this so it finds me a solution in under five minutes... I have a list box lstDept that enables me to select multiple departments, I've got this working in feeding...

I'm sorry... I'm having a complete brain lapse with regard this... I've got no idea how to begin calling this function and getting it to pick up the correct date fields for the different locations... dteStartDate = [forms]![frmQuery]![txtStart] dteEndDate = [forms]![frmQuery]![txtFinish]...

Ok - I may be doing this a long way round... I've created one query "qryIndvDailyHoursbyProject" SELECT qryIndvSelect.[Entry Date], Sum(qryIndvSelect.[Total Hrs]) AS [Project Hours], qryIndvSelect.[Project Name] FROM qryIndvSelect WHERE (((qryIndvSelect.[Entry Date]) Between...