Thank you,

It took some playing but I got it working.

Now the real work begins.

I use both form and datasheet.

I can see how this might work with a form. I could either have one update statement for each text/check box for one for...

Sorry about bumping this up.

Does anyone else have this problem?

How do they solve it?

Thank you,

It is going to take me a bit to figure why/how the Coalese works with the reverse, etc..

In the meantime since it saves on performance I have switched to it....

I never thought of using a 'double reverse'

Thank you very much, that was great and works no problem.

Is that going to work with the name: John Q. Public to give me:

First Name = 'John'

Last Name = 'Public'

Many thanks...

Putting the On ... right after each table is MUCH easier that the way I was doing it.

Much easier to follow, etc...

Thank you again.

Okay...

That looks very clean. I need to do some reading up on the difference between a Left Join and a Left Outer Join.

If you are asking about Keys.

The keys are:

tbl_Drawing: The keys are not used in the join - Company, Division, Drawing, Revision, Area;

- Drawing_ID is not a key but is...

Actually I'm a little embarrased to admit it.

I took a second look at the query and I am not adding (or finding the min, max, avg, etc...) anything.

So, feeling a...

That really helped.

Thanks to both for your help.

I suspect I am getting an INT from the iSeries.

In the vtbl_TCH_First_Labor table it could be either a Null which I convert to 0 or the YYYYMMDD format.

In the other table it should always be in the YYYYMMDD format.

However,...

I tried and tried using different versions of what Lynn provided, using with and without Convert.

I kept getting errors. However I just tried

YEAR(dateadd(mm, -3, Convert(smalldatetime,str(START)))) As Job_Start

and it worked.

Yeah!!!

I...

I also tried

Case

When Start > 0 Then Convert(smalldatetime,Start)

Else 0

End

As Job_Start