Thanks for your help guys !

Matt

Ron,

I have put your advice to good use and solved the problem.

Thanks very much

Matt

Thanks Lutz, this is exactly what I needed. The application uses the 0 date as Jan 1st 1801 so I have to do some conversion work anyway !

Matt

Hi,

Thanks for the reply. I've had a look at the thread. I'm not sure it answers my question. I'm looking for the serial date like Excel produces, ie an integer...

Hi, that's great I'll give it a go. Thank you

Yes, just realised this by playing with it. I thought it would try and group by every variable, I didn't realise it would work out the group by primary key...

Once again, thank you for your time.

The cnumber would be something different to the CID. The actual application is that we have a customer table with unique a unique CID...

Thanks for your help Matt

I am very grateful. An added complication, what if there is another table called CUSTOMER, and there are is the same CID column. What is I...

Thanks Ken,

Looked like I was over complicating it !

Matt

Hi Guys,

Thanks all for your help.

I came up with a solution, substitute customers for nurses, orders for jobs and date for weekno

select count(distinct nurses.nurs_id) from nurses join jobs on jobs.nurs_id=nurses.nurs_id

where...

Thanks alot, worked fine and I learned something new !

Thanks for all your help, I shall be reading up in this then.

Do you get an SSPI error ?

If so read everything you can about SSPI, then give up and use basic SQL authentication.

Yes, basically. I want actually to do something a bit more exciting, but I just like to understand...

Hi,

Thanks for the info. Unfortunately I cannot quite understand how this fits together. Let's call the...