Update Part# field where is blank

Hello All,
i have the following two fields Part# and Cust#
Have some records that have blank part number but contain
a Cust# example,
PART# Cust#
zxe35
SER98
XR25 ZR25-R

Is it possible to copy the Cust# into the Part# only for
those records that are blank? Since I'm running a query
based on the Part# field, I will not get those records
with blank part number so want to make sure I copy the
Cust into its respective part# field.
Please advise if its possible.
Thanks,
juan

Use an update query

UPDATE Products SET Products.PART# = Products.Cust#
WHERE (((Products.PART#) Is Null));

HTH
Damon


"JUAN" wrote in message
...
Hello All,
i have the following two fields Part# and Cust#
Have some records that have blank part number but contain
a Cust# example,
PART# Cust#
zxe35
SER98
XR25 ZR25-R

Is it possible to copy the Cust# into the Part# only for
those records that are blank? Since I'm running a query
based on the Part# field, I will not get those records
with blank part number so want to make sure I copy the
Cust into its respective part# field.
Please advise if its possible.
Thanks,
juan

Use the NZ function

SELECT Nz([Part#],[Cust#]) as MyPartNo
FROM YourTable

That will do show Cust# in the calculated column when Part# is Null.

If you want to PERMANENTLY do this in the table, use an update query.

UPDATE YourTable
Set [Part#] = [Cust#]
WHERE [Part#] is Null



JUAN wrote:

Hello All,
i have the following two fields Part# and Cust#
Have some records that have blank part number but contain
a Cust# example,
PART# Cust#
zxe35
SER98
XR25 ZR25-R

Is it possible to copy the Cust# into the Part# only for
those records that are blank? Since I'm running a query
based on the Part# field, I will not get those records
with blank part number so want to make sure I copy the
Cust into its respective part# field.
Please advise if its possible.
Thanks,
juan

On Wed, 18 Aug 2004 14:20:31 -0700, "JUAN" wrote:

Is it possible to copy the Cust# into the Part# only for
those records that are blank?

Yes, though in my opinion that's a VERY strange thing to do! Customers
are not Parts (I hope...!) and it sounds peculiar to assign a Cust# to
a part.

But to do so, create an Update query such as

UPDATE yourtable
SET [Part#] = [Cust#]
WHERE [Part#] IS NULL


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Hello All,
just would like to thank all of you for providing help. I
guess my brain was sleeping. Once again thanks alot.

Juan
-----Original Message-----
On Wed, 18 Aug 2004 14:20:31 -0700, "JUAN"
wrote:

Is it possible to copy the Cust# into the Part# only for
those records that are blank?

Yes, though in my opinion that's a VERY strange thing to
do! Customers
are not Parts (I hope...!) and it sounds peculiar to
assign a Cust# to
a part.

But to do so, create an Update query such as

UPDATE yourtable
SET [Part#] = [Cust#]
WHERE [Part#] IS NULL


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
.