Update query

[gsrajan]

Please help me..

I have around 5000 customer ids ( field name: CustID ( 45632, 46372, 85633.... ) data type text. I need to update the field called ContactedOn with a date 10/10/2014.

Please let me know what is the best way to do this. I tried to use the query builder, but it says "text too long", may be due to large data.

Thanks for your help.

 

[jdraw]

Please show us your table design.

TblName
fld1
fld2
etc

 

[CJ_London]

suggest you post your query sql - text too long sounds more like an error in the sql rather than large data

 

[gsrajan]

Thank you.

Table Name: MasterData
Field1 : CustID ( Text )
Field2: GivenName
Field3: LastName
Field2: ContactedOn ( Date )

I need to update the ContactOn field with date where the CustomerIds are the 5000 numbers (Criteria).

Sorry, I deleted the query since it was not working.

Thanks for your help

 

[jdraw]

UPDATE MasterData
SET ContactedOn = #10/10/2014#

 

[gsrajan]

Thank you jdraw. But I am not updating all the records in the table. Only around 5000 records.

Thanks,

Rajan

 

[CJ_London]

UPDATE MasterData
SET ContactedOn = #10/10/2014#
WHERE ContactID between 5000 and 5999

 

[gsrajan]

Thanks CJ,

But I am not updating all the records between 5000 and 5999. Only the relevant records. That said, I need to specify each CustID in my update query.

Thanks again.

 

[jdraw]

gsrajan,

It would help readers and yourself if you could write -in plain English - What you are trying to do INCLUDING all relevant criteria.

 

[gsrajan]

... I may update CustID 5000 and may not update CustID 5001, may update 5200 and may not update 5330...

Hope this helps.

thanks again.

 

[CJ_London]

may or may not based on what? The weather? time of year? colour of the wallpaper?

 

[jdraw]

As CJ has pointed out, WHAT are the criteria involved for iincluding/excluding certain records?