Recent content by FannyPerpendicular

I'm creating a form to count the number of employees with birthdays between 2 dates. There are 2 unbound date fields; Start_Date and End_Date. I have an Employee table with DOB field. I've been stuck on how to get the field to return the correct number of employees that fall within the 2 dates...

Thanks! I ended up creating each Iif criteria seprately and then joined the. I managed to get all 7 in and working!:D

Hello, I have an unbound Text Box [D] in an Access 2007 report. The results of that Text Box are based on information entered in 3 other Text Boxes. I've tried to build an expression but end up with errors. I'm thinking VBA might be a better way to go. I don't have much in the way of VBA...