Recent content by Emma35

Pat i understand what you're saying but i'm just not 100% clear about how removing the child table would fix the issue. What am i looking for when i open the query ? Thank you for your help

Thanks Mark.....i redesigned the report to omit the subreport and grouped the data as you recommended. Works perfect. Thanks a lot for the help.

Sorry guys i sometimes forget you're actually human :) I've attached a smaller version of the database. To add records you use the frmClothingIssue. To search use frmSearchOptions1 and the report in question is rptSearchResults. Thanks for the help all

Hi All......i'm back a bit sooner than i thought I'm updating a database which records the dispensing of safety equipment to employees. I have a main form which records the person's name, ID number etc and then a subform where you use combo boxes to list the equipment given to that person. My...

Thanks DBguy the first option worked fine. Got it going now. Gasman.....yes i was using the subform name and not the control. All ok now thanks

Below is the closest one i can find in there to my problem but it doesn't work ? Me!Subform1.Form!ControlName

Hi Everyone.....i have a quick question regarding cascading combos. I have two of these on a subform and i'm trying to make a selection in the first which controls what's visible in the second. I have the Rowsource of the second combo set as below but i think i need to reference the parent form...

Well it looks like you were right to ask a 'silly' question because i've just worked out the problem. The cell where i was entering the formula was (for some reason) formatted as text. Honestly i never even thought of checking something so basic. My fault for not checking the obvious things...

No it's a fair question. Formula below

It's not even working for the first criteria "Section A". I'm just seeing the formula in the cell when i press Enter ?

I replaced the P and no difference

Ok there's another column (B) which contains an actual date but column (P) contains the formula below (which i'm told converts the date to a period) eg: January in this case so all the late deliveries for a particular period can be counted. So the date 28/01/25 is converted to 2025-01...

Ok so do i need to use different syntax because it's a date ?

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