Replace Data More Than One Field 1

[surfbum3000]

How can I replace multiple values in one field?

UPDATE tblxAppts2Weeks SET ENDTIME = Replace(ENDTIME,"10:59","11:00")

Now I want to add:
Replace(ENDTIME,"14:59","15:00")
Replace(ENDTIME,"13:59","14:00"), etc.

 

[dhookom]

Is your field type text or date/time?

Can we assume you want to add one minute to a value if the "minutes" portion of the value is "59"?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[surfbum3000]

Data type = text

Your assumption is correct. If any field has :59 I need to add 1 minute.

 

[PHV]

UPDATE tblxAppts2Weeks
SET ENDTIME = Format(DateAdd('n',1,[ENDTIME]), 'hh:nn')
WHERE ENDTIME Like '*:59'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[surfbum3000]

Very good. Worked like a charm. Thanks.

 

[dhookom]

I would create an update query like:

UPDATE tblxAppts2Weeks 
SET EndTime =Format(DateAdd("n",1,TimeValue(EndTime)),"hh:nn")
WHERE RIGHT(EndTime,2) = "59";

You might want to test this first with this sql:

SELECT EndTime, Format(DateAdd("n",1,TimeValue(EndTime)),"hh:nn") As NewEndTime
FROM tblxAppts2Weeks 
WHERE RIGHT(EndTime,2) = "59";

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]