Search results

Those numbers were meant to be placeholders. Apologies for the confusion. Table Name:TermsByYear2018 Field Name: TermMonth Criteria: Last Month I would like for a textbox to show a count of the above criteria based on the selection of combobox (cbomonth).

This is what I am doing: I have a query with names, term dates, term months, term months and years on it. I would like to have a form with a combo box that lists the years, and a combo box that lists the month that would count only those records in the query and return a number. For example...

So I have the two combo boxes set up like the attached. One to select a year and one to select a month. When a year is selected (without a month selected), I would like to be able to see just the yearly attrition percentage. When a month and a year are selected, I would like to see the monthly...

Hi all. I am trying to track attrition at work. So, I have a form created with 2 combo boxes, one for month and one for year. I need a text box to calculate sum(Termsforthemonth)/sum(EmployeesAtEOM), based on the year and month selected in the combo boxes. I hope I explained that well enough...

This is perfect! Worked like a charm. Thank you so much!!

Please help. I have been working on this for days and have no solution. My code is not displaying an error but it is also not displaying my populated email. Once I have the VBA correct, then I don't know how to call it via a command button. Pretty new to this coding thing and I learn everything...