Search results

Solved , thanks everyone!

Sorry , but how I do that? Could you please clarify step by step.

I wish to get every Sunday a list of employees with the upcoming birthday.

It opens Access but not sending queries..

I wish to get notified every Sunday in 9AM o'clock with the results from the MS Access query. What's the best way to do that? Thank you

Thank you , understand, I will try that.

Assuming it has 7~14 layers, may I build the with CASE statement in VBA as it more readable?

I'm adding records into employee table. Where new employee is engineer he gets a degree "4" (calculated field). If new employee architect , het gets "5" , e.t.c.. There are many IIfs..

I can make one condition expression , as shown, however I have more than 10 conditions. I do prefer to build them as a nested IIF statement in VBA. What's the right way to do that?

Yes, sure.. please.

Could you please help with the syntax? The DB is attached.

Managing Dynamic Emails in EMailDatabaseObject I have a query that alerting once an employee has a birthday. Now I wish that "..wishes" report will be sent to that employee. I can put in AutoExec only static email , a@b.com but not relevant employee email from a table..

I took your solution , however when I was trying to add DegreeDate column the output was changed. Apparently I was missing to add "Max" also to that column.

I've marked DegreeDate as Max and it solved the issue. Thank you, guys, for your help!

This one partially did the job, however when I put also DegreeDate column it shows me non-relevant record as well?!

In this particular case nothing.

Hereby please find attached, Let's assume I'm putting "23" in Degree, then I don't want John to be shown as he has also 76. Hoping it's clear..

I'm a newbie in Access, may you add a screenshot how it looks in Access (not SQL). Sorry for that..

Yes, but I want to get only those records where 50 is the higher degree. If same ID has 60, 70, e.t.c not to show also 50.

Having a table DegreeDate Fields are : ID, DegreeDate, Degree. Each ID may have more than one degree. Wish to build a query that shows only those whose degree is 50. If same ID has higher degree he will not be shown. Will appreciate your help..