Search results

I've just realised, its only one job number I need to exclude - 2018 - I've excluded it from the query which is fine and then the report. I just need to now exclude those weeks with less than 5 days. Not sure if I'm going about it the right way though but I am trying.

This is brilliant, thank you so much! Only problem I've got now is when I add the task to your query it breaks it all down again. I need to somehow exclude weeks with specific Tasks as these weeks are not allowed to be part of the average calculation but I'll try and have a play with that 😬...

Those results look great 😁 I've just got to work out how to get those into my DB. I totally know what your saying, I knew nothing really about databases when I started creating, I just happened to be able to goggle a couple of computer issues and solve them in our very small office and...

Hi MajP, Thank you loads for all your time. I've attached a very scaled back version just including what you require and left me on there as an employee with random wages. I hope that's what you mean! 🤞

Sorry I didn’t make that clear before and thank you for sticking with me! There will always be entries for Monday to Friday, but some of them maybe zero, if off sick for example. However, I do need Sat to Friday, as they may’ve done overtime at the weekend. The report I sent was just a very...

Hi, thank you to you both for trying to help, I've tried both of those with the same result. It's still working out the average on each record, whereas I need the average for the week but only for the different days in that week? I don't think I'm explaining too well! As the first example...

Thank you for the welcome, Luckily, I 'think' my tables are all good and always start there before going onto creating any new forms, reports etc. Although, I seem to have committed a cardinal sin by using spaces in my field names 😬! Hasn't got me into too much trouble so far but I do now...

Thank you for your reply MajP, I received it on my email but not on here? Not sure if I'm doing this right, as I said first Forum! Please see attached the Design view for the previous report, I think that is what you described? However, this is still averaging on records, not dates? Thanks again

Hi , this is my first post, so please forgive my ignorance and I hope I've put in in the right place! I need to work out an average pay of an employee for the week. I've run a very basic report to try and show you what I mean. This is all to do with calculating employees average pay over the...

Good morning to you all, how to describe myself? Not really sure. I just getting a little excited about DB's, excel etc and nice to know I'm not on my own! I am very much self taught and ended up building a database for the company I work for (when the current one they had paid for many years...