Update queries

F

Fernando

How can I change the values in a table, example:

PO-05-R-VTR132-1 to PO-05-R-EUR132-1

PO-"00"-R-"AAA000"-"0"
 
K

Kai Apel \(Berlin\)

Fernando said:
How can I change the values in a table, example:

PO-05-R-VTR132-1 to PO-05-R-EUR132-1

PO-"00"-R-"AAA000"-"0"
Click to expand...

Go to the record you want to change and change it! Or what do you want to
do? It´s not clear, what do you want to do and how are your rules for
changing the value. I need more information about what do you want to do! If
you only want to change VTR to EUR then you can use search/replace or you
can use in VBA REPLACE(Name of Your String,"VTR","EUR") otherwise you can
separete the string and change what you want. With InStr(Name of Your
String,"WhatToFind")>0 You can find any part of String.
Hope that helps.

Kai Apel (Germany-Berlin)
 
F

Fernando

Hi Kai Apel,

I will explain better to you:

Those numbers are numbers of purchase orders, I have about 200 purchase
order for each project, example:

PO-"year"-R-" customer+No"-"issue"

The mask of this field is: "PO-"00"-R-"AAA000"-"0""

PO-"05"-R-"EUR101"-"1" to PO-"05"-R-"EUR301"-"1"


I have two tables "purchase order" and "purchase order details" when i have
those informations.

When I need build a new machine, I need to issue all those 200 Purchase
Orders again, then my ideia is: I make a query update when I could change the
name of customer, and the same time I create another 200 PO for the new
customer, with the same dates, informations about the last customer.

Thanks,

Best Regards,

Fernando Carvalho
Depto TI
 
Top