Search results

Ok i took those commas out and my formula is below but no luck =SUMIFS(MainData!N2:N30747,MainData!C2:C30747,"Section A",MainData!L2:L30747,"Late",MainData!P2:30747,"2025-01")

I'm summing all the number '1' values to get a total of how many deliveries were late. The other columns just denote the production area (Section) and time period (01-2025) which is Jan 2025

This is a worksheet i 'inherited' and can't change so i just have to work with it.

Hi David....yes i'm sorry that's correct. I should have explained it a bit better. Column N will either have a '1' representing Late or '0' representing Ok

Hi Everyone, Could someone have a look at this function and tell me why it's not working ? =SUMIFS(MainData!N2:N30747,MainData!C2:C30747,"Section A",MainData!,L2:L30747,"Late",MainData!,P2:30747,"2025-01") Some background info The formula i'm working on is in the same workbook as MainData...

Hi again all......i've made some changes to the table structure which solved the problem. I think i was guilty of trying to find a quick solution using VBA when the answer was right in front of me. Thanks everyone for pointing me in the right direction as always. Em x

Hi everyone......first of all thank you for the great suggestions. I caught a bad bug before Xmas and have been in bed ever since so haven't got back to this until this morning. I'm going to try a couple of changes and will get back with the results

I realise now i probably haven't explained this very well. The same database is used in Area A and Area B. The information is scanned in from a barcode. So, there are items in Area A that don't belong in Area B and vice versa. If somebody scans a pallet in Area B which only belongs in Area A i'd...

Thanks for the suggestions guys. What code would i need to put in the AfterUpdate event ? A B C and D are different areas in a factory setting and i don't want the wrong items scanned to the wrong area

Hi Everyone, I'm using a data entry form and i'd like to restrict what data users can enter based on a previous combo box selection. For example, if my combo box has the options A, B, C or D, then if the user selects option A i'd like to prevent them from entering a certain product number...

Hi KitaYama your suggestion works perfectly thank you. It was initially generating some kind of syntax error but i shut down the database and opened it again and all was fine. Thanks again for taking the time to help and also to everyone who made suggestions....i'm always amazed at the help and...

Thanks MajP i'll try omitting it and see what happens

Thanks KitaYama this version looks promising........i need to get a couple of boring meetings out of the way before i can give it a proper try. Cheers

Thanks KitaYama....there's an error popping up on the AfterUpdate event about communicating with the OLE server ?

CJ the boxes are just blank when i try adding new records Edit : Sorry CJ i had to unblock the file before your code worked. I was wondering if there's a way of doing it without the PK ?. The counter can keep on counting away as long as it restarts when reset to zero ?

Thanks MajP. I tried the below but still no luck =DSum("[Weight]","[tbl_MainRecords]",)

I don't need to sum all the records Gasman. The records are entered into the database using a scanner. The reason for this counter is that the operators need to record exactly how much raw material was used to fill a particular tank. This is only necessary for one tank and the rest of the time...

GaP42 i definitely don't want to reset the records in the table to zero. I just need a counter which can be reset to zero without affecting the underlying table

My VBA is not good Gasman. I tried the code below but it just turns red as soon as i type it DSum ( Weight, tbl_MainRecords)

Ok i didn't know that gasman. How do i use the DSum() event ?......my VBA is atrocious. Thanks