yep, you are right on the money with your understanding of what I am trying to do.

I have finally gotten it to work the way I want it.

I ran the...

hi David!

Let me explain how excel came into play.

There are 3 ways that I know of how to automate the process of moving data from access to someplace (either another...

thanks for your response.

Select * from OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source="\\Servername\Shared\Example1.mdb";User ID=Admin;Password=;')...Tablename

The method above would be great for what I am trying to do but the problem I have is I can't...

thank you very much!

Yes, the query knows supervisor, employee and director through type.

when records are pulled into the notification table for emailing, it breaks type type up into employee, supervisor and director and...

This won't work because the email program is supposed to pick up records that have missed deadline.

Example, if an action is not taken with regards to a particular event within...

sorry, guarddata and mccork.

Last time I was herem, I was working from home.

As soon as I discovered that I had been testing this sp incorrectly all along, I came back...

thanks guarddata and mccork!

I tried both responses and like mine, I keep getting the below message when I try testing.

Procedure 'mainInput' expects parameter '@orgcode', which was not supplied.

I was looking...

sorry it should be more like this:

tblAccidentEvent table relates to theEmp by empID

tblAccidentEvent table relates to tblAccidentInfo by trackingNumber

tblAccidentEvent table relates to countyDriver by accidentEventID

tblAccidentEvent table relates to tblVehicle by...

tblfactors is the table with two fields

factorsId int

factorsDesc varchar(50)

so we have

factorsID factorsDesc

1 ...

I have got everything working now the way I want it.

Thanks for your input.

I wasn't actually passing in empName.

I was using that as an example but I do understand what your example is saying.

For instance, if I need to retrieve the value of...

that's exactly what I am looking form.

Thank you fromnaija.

Sorry to both of you for my late response.

I was out in the field.

By the way, s the fname, lname values editable...

hi mandard!

I understand what you are saying and it makes a great deal of sense to me.

The logic appears to be fine with me.

But I have a problem.

if last_action taken...

hi Mandard,

thanks for your input on this.

I am still trying to sort out what you have done here.

I mean, I understand what the datediff function is doing but I still...