Search results

You're all brilliant - Thank you!

You're all brilliant - Thank you!

That is exactly what I need, thank you so much for coming to my rescue yet again!! Not wanting to push my luck, but I have this found this command on the internet - DoCmd.SendObject acsendNoObject,,,"jillnoble@tubesscaffolding.co.uk",,,"Wage Slip Breakdown","Please find attached your wage slip...

Arh, I see what u mean, once you know the company name you can get all those details from companies house anyway so didn’t think that would be a problem. But yes, see what u mean about Keith and the wages. My mistake and am very sorry. Just didn’t know how else to get the help I needed. Apologies.

Ok Uncle Gizmo, no problem. I thought it would be ok as no addresses, email addresses, phone numbers etc (except mine) only random names. However, I totally understand. Thank you

Thank you so much but I’ve kinda lost the Will to live with it at the moment! This looks great but I don’t even know where to put it! Like I’ve said to thedbguy, I think I’m going quite a way out of my understanding. Thanks for trying though!

Thank you DBguy but I think this may be a bit above me. I can’t even get the outputto to work! I’ve googled it, Copied, pasted and amend to my own names etc on several different versions (I assume I put that in the vba of the report?) I think I may have to think of another way round. I may just...

Hi, This discussion seems to have been covered several times in many places, so I'm sorry if I've out this in the wrong place! I've been trying for a few days but no matter what code I use I cannot get it to work. I am very unfamiliar with code as I only set this DB up as a favour for work...

Thanks again, I think I've now sorted this but am now getting "Data type mismatch in expression" I've tried lots of things looking at different problem solvers but can't seem to sort it and I really don't think I'll have any hair left after this! Again Its happening on the weekly query. Could...

Hiya, me again. It is, perfectly within that DB, however, when I've now tried to bring it into my DB, the 'qryDailyPay_Not2018' is fine but as soon as I move onto 'qryWeeklyPay_Not2018_5orMore' I get -"Undefined function 'format' in expression" as an error message?

Hi MajP Thats brilliant! Thank you so much for ALL your help! That works so well! I just can't say thank you enough!!!

Hi, Don't understand what AFAIK is? I've taken a screen shot of what I get from the 'qryAvgDailyPerWeek_Not2018' and it includes days/weeks after wk 31? Think I've solved it with this? Although now I need it to total the averages but not all of the averages, just the weeks. If I try to total it...

I've added another employee if that helps?

Hi Poppa Smurf, thank you for joining! Was so worried I was putting it all on MajP! I like what you're thinking, Basic pay and Overtime (Not bonus, needs to be the average, MajP, don't worry, didn't like to say as you've helped me sooo much, was just gonna take Bonus out of the equation) Yes, an...

Thank you, that's brilliant, but dare I say it 😬 (you're gonna wish I never joined this forum!), still not showing any details after wk 31, even though it does on the Avg qry??

The report is still showing 2018? The 'qryAvgDailyPerWeek_Not2018' looks good, but the final qry, which filters out >4 then has 2018 included? and weeks 38, 39, 40 for example, are on the AvgDaily qry but not the final qry. I'm confused!

Thank you. Sorry for not saying thank you earlier but I've been trying to sort this on my own but I just can't get it. I've now noticed that when I go back to your latest qry (qryFullWeeksWorked_Not_2018) it stops at wk 42? and when I added the filter you suggest above it stops at 31? I tried...

Thanks again, As you've stuck with me this far maybe you could take a look. I basically used the report wizard, bunged everything onto the report and grouped on Employee, Year and Week just to see but if you look at week 15 for example, its still included that week even though there's only 4...

Thanks again MajP, You'll have to start charging me! Ran a very quick report and it's excluded weeks 5, 7, 8, 10 + 12 but then included week 15 which also includes job 2018? If I try and exclude that within the query it just messes all your good work up! Perhaps I've been staring at this screen...

I need to exclude that week altogether. So I need to run a report/query with days average of 52 full working weeks pay (Job 2018 isn't a working day so the whole week needs to be excluded) as from Jan 2021 onwards that's what they will get paid every time they take a leave day.