Recent content by bluke829

Thanks, but I've tried that, however, my next step is to average, by person, by month all of the scores except the lowest each month, so a query with just the lowest won't help get to the final result. Any other suggestions?

Hi, I have a table with Name, date, test score. I've been asked to determine the lowest score for each person, each each. I'm stuck trying to create the IIF statement in query based on this table. Below are some record examples Employee1, 5/1/17, 90 Employee1, 5/10/17, 85 Employee1...

I have a table that lists employee name, date, Absent Type(AllDay,Late or LeaveEarly and Value (1 for absent and .5 for Late or LeaveEarly). If The employee is listed as absent in this table the point value is 1. Here is my question: if the employee is absent for two consecutive dates (e.g...

Hi, My company is moving to Outlook soon from Notes. I'd like to know how to change the below code to send from Outlook instead of Notes. This code sends an access table (table1) to a list of recipients every hour. The table is placed directly inside the body of the email. Its a small 4...

Hi, I'm new to VBA because I inherited an access db from a former colleague that contains a module written in VBA that I've been asked to modify. This code extracts 'TABLE1' from the current access db and emails it to select individuals. what do I change/add in the code below to be able to...