Thanks That work a treat, i have now been able to finish my report, Looks good too.

Vladan,

That works brilliantly, especially when i spell the tablenames correctly

Thanks for the help, this is an ongoing project thats gonna need a lot of help here and there, so thanks...

Also,

What will happen if i re run this statement tomorrow when i have imported tomorrows data and got Null values, Will it just update what it can or will...

Thank You,

That worked like a dream, I can now update my Crystal Reports as i have had to change some table Names..

This should help me immensly. I now have to...

Thanks for that,

This should by design be a 1 to Many relationship as far as Table 1 Is ShiftDate Ie will be StartDate(09/09/2007 06:00:00) EndDate(09/09/2007 18:00:00) and StartDate(09/09/2007 18:00:00) EndDate(10/09/2007...

Thanks for the reply,

Details are.

Table 1

Downtime_ID | StartTime | Shift_ID | Duration

1 |...

Reading Previous Posts i have managed to create the Primary Key on each of the tables that i need to use, I now need to insert a Foriegn Key into...

I think it was because i was using the Access connection rather than the SQl connection

Steve

Sorry Double Post

Adrian,

Really sorry to keep troubling you like this, but way back at the beginning:

I missed the parameters button i get a parameters error " The SQL STATEMENT DOES NOT CONTAIN...

Adrian,

I now see that i still need the Execute SQL Task, I have done as you said and added the whole line because the paths will never change only the...

It is acually a directory on the server where all the data will be stored.

I am a little confused now, sorry about this.

I got the above file path from the...

Adrian,

That works fine for the filename, But in the next stage i need this filename to be inserted to the

\\Prodigy-2\tascomp ltd\Prodigy\Data\DownTime\03CDP_Low_Moor_Line_3\20070830.mdb

How do i declare that as a variable and...

Adrian,

Thank you very much for that, I will go ahead and try this and let you know what problems i can come up with

Regards

STeve

Adrian,

Thanks for the reply, I have already done the DTS Package for importing the data, but this has to be done manually on a morning, this is due to...