Search results

Can't quite get my head round how to write this but I know it can be done. I have a form with a field called duration. The user selects AM,PM or All Day from a list If the user chooses All Day I want to create a duplicate record DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand...

Hi Gerry That was my first thought but there were a couple of issues. The big problem is that things change. I might book someone to a project for ten days and then need to take them out for half a day on day three. If I work with a date range I would need to change the date range, add in...

Hi Guys I have almost no experience of VBA outside of working a little with codes generated for me like docmd etc. If I can explain in English what I am trying to do can someone point me in the right direction to start creating the code. I am trying to create a database for resourcing staff...

Thanks All Paul gets the prize. I do use lookup tables where possible to ensure the correct entry format but when I took the lookup off the original Iif calculation worked without any amendments. That was driving me nuts. Thanks again

As in the screenshots from earlier. It runs the query but shows #ERROR instead of a number in the result

Thanks Paul.. I see where you were going with that but unfortunately it still returns the same error.

Hi All I'm not technically a new member but I've been away for a while. About four years ago I created a database for recording the activities and hours worked for my team. About two years ago I updated it. It became a big hit and it's used in all sorts of ways to analyse what training we...

Here you go: SELECT Resourcing.Project_Title, Resourcing.Start_Date, Resourcing.End_Date, Resourcing.Time, Resourcing.Trainer_Name, Resourcing.Training_Type, dhCountWorkdaysA([Start_Date],[End_Date]) AS [Work Days], Resourcing.Activity, IIf([Time]="All Day",[Work Days]*7.4,[Work Days]*3.7) AS...

See if the attached PDF helps

Sorry Dan. Got you now. I'm working in a query. Creating a calculated value based on other fields in the same query.

I want an append query to duplicate a record I create but change the date. Let me try to explain. I create a record that records someones activity between a given start date and end date. I have a query that works out how many working days between the start and end Let's say the query says...

The result of the Iif statement will create the figure in the new Total Hours column. I'm using the expression builder function. Does that help?

Total Hours: IIf([Time]="All Day",[Work Days]*7.4,[Work Days]*3.7) So what I am looking to return in English is: If the time entered in the Time field is All day then multiply the figure in the Work Days field by 7.4. If the entry in Time isn't All Day then multiply the figure in the Work...

Thanks Plog. I'm still kind of working between this and excel. I'd rather use acces as it's more stable but excel seems more inclined to give me the kind of out put I want. Six months could work provided it could be a rolloing six months i.e in January have the default display between...

Thanks Plog. It's frustrating when you know what you want to do but lack the skills to do it. I think you are right and I may be being overly ambitious. My next thinking would be to use a form for input that would update a master table and then have the master table update an excel...

Thanks Caz I wanted the dates as columns as I intend to have the column width tiny and have a scrollbar along the bottom. Provided I get it to open at the present date then I hope to see the activities of about 30 folk for about a quarter at a time. I hope that makes sense. I do it with a...

I'll probably have a hundred questions following on from this one. What I'm hoping is that someone has maybe tried this before and has an example that I could reverse engineer. I want to create a cosstab query with dates for the next 12 months accross the top as columns and employee names...

Number_of_days is the amount of working days (took ages to get that to work, ended up copying someone elses VBA code without any real idea how 0or why it worked). So I had a start time and an end time to give me an amount of hours per day then multiplied by the amount of working days. I got...

Hi all, I'm returning to access after quite some time and discovering that I have forgotten how to do even basic stuff. I am starting to create a resourcing database that needs to be able to work with dates and times and perform calculations on them. I need to work out the number of hours...

Thanks for the reply. I think I might have worked it out though. Users input their hours each week using the week commencing (w/c) date. I'm forgetting that although people have taken holidays last week they will all be reporting as being taken W/C 31st March (i.e last year). Just not...