Hello

Just confirming that I've successfully got it working now.

Thanks a lot for your time and help everyone.

Sample

SELECT 'PL06' + CONVERT(char(7), Vendor)+'_' + ShipTo

FROM PL06

Actual

SUBSTRING('PL06'+ CONVERT(CHAR(7),RTRIM(Vendor))+ '_' +RTRIM(Shipto)+'_'+RIGHT('0'+LTRIM(OrderPeriod),2)+''+RIGHT(RTRIM(CONVERT(char(20),GETDATE(),112)),6)+''+CONVERT(CHAR(8),SYSDATETIME(),114),0,35)AS[DocumentNo]

Sorry ignore my last comment i was reviewing it in 'Results to Grid' instead of 'Results to Text'

Cadavre (1/11/2012)

---

Jnrstevej (1/11/2012)

---

Many thanks for your reply

The problem that i see with the example that you have provided is that is sets the vendor to 1001.

I want the...

Many thanks for your reply

The problem that i see with the example that you have provided is that is sets the vendor to 1001.

I want the code to...

Hi okbangas and Cadavre

I've tested the code you guys suggested and I'm getting the results i want. I didn't expect it to be a simple change. Thanks a lot for...

Hello

Allen thanks for the advice.

It would seem I've answered my own question lol. Just in case anyone else is experiencing the same problem or would like to achieve the...

I've found the information i need to link SQL Server to Access, so ignore my previous question.

http://office.microsoft.com/en-us/access-help/import-or-link-access-to-sql-server-data-HA010341762.aspx?CTT=1

Can you tell me instead how to delete data inside of MS...

Thanks for your reply Drew for your reply.

I'm definitely open to new approach, do you have any information or any step by step guides on how to do this...

Hi GSquared

Many thanks for your reply. I'm in the process of trying to get a copy of the database(very frustrating)once i have it i'll upload it and maybe that will...

I've made slight adjustments to your sample code which has given me the results that i require. I must admit date functions are not one of my strong points...

Thanks @cadavre for your time and effort I'm currently working through this now once I'm done I'll post my results

Yes your right it should be from October and include Nov 12 miss that out

The adjustments you have made is perfect the other 2 questions i have is the...

Brilliant thanks for that.

Another question how would i control the dates that i want to show and increment it by 12 months according to the current.

For example,...

Thanks in the process of testing this now

Any luck?