UPDATE QUERY

M

Mike

This is my Select query. How can I change this to Change the
TENDSALE.RECEIPT_NUM to = NEW_RECEIPT_NUM
I don't want to add records just increase the RECEIPT_NUM by 2000

SELECT TENDSALE.RECEIPT_NUM, [RECEIPT_NUM]+2000 AS NEW_RECEIPT_NUM
FROM TENDSALE;
 
R

Rick Brandt

Mike said:
This is my Select query. How can I change this to Change the
TENDSALE.RECEIPT_NUM to = NEW_RECEIPT_NUM
I don't want to add records just increase the RECEIPT_NUM by 2000

SELECT TENDSALE.RECEIPT_NUM, [RECEIPT_NUM]+2000 AS NEW_RECEIPT_NUM
FROM TENDSALE;
Click to expand...

UPDATE TENDSALE
SET TENDSALE.RECEIPT_NUM
= TENDSALE.RECEIPT_NUM + 2000
 
M

Mike

Thanks Rick

Rick Brandt said:
Mike said:
This is my Select query. How can I change this to Change the
TENDSALE.RECEIPT_NUM to = NEW_RECEIPT_NUM
I don't want to add records just increase the RECEIPT_NUM by 2000

SELECT TENDSALE.RECEIPT_NUM, [RECEIPT_NUM]+2000 AS NEW_RECEIPT_NUM
FROM TENDSALE;
Click to expand...

UPDATE TENDSALE
SET TENDSALE.RECEIPT_NUM
= TENDSALE.RECEIPT_NUM + 2000
Click to expand...
 
M

Mike

Rick
I'm trying to replace the 2000 with a textbox value.
What am I missing

strTendSaleSQL = "UPDATE TENDSALE " _
& "SET TENDSALE.RECEIPT_NUM = TENDSALE.RECEIPT_NUM+" & strReceiptNumbers
& ";"

Rick Brandt said:
Mike said:
This is my Select query. How can I change this to Change the
TENDSALE.RECEIPT_NUM to = NEW_RECEIPT_NUM
I don't want to add records just increase the RECEIPT_NUM by 2000

SELECT TENDSALE.RECEIPT_NUM, [RECEIPT_NUM]+2000 AS NEW_RECEIPT_NUM
FROM TENDSALE;
Click to expand...

UPDATE TENDSALE
SET TENDSALE.RECEIPT_NUM
= TENDSALE.RECEIPT_NUM + 2000
Click to expand...
 
R

Rick Brandt

Mike said:
Rick
I'm trying to replace the 2000 with a textbox value.
What am I missing

strTendSaleSQL = "UPDATE TENDSALE " _
& "SET TENDSALE.RECEIPT_NUM = TENDSALE.RECEIPT_NUM+" &
strReceiptNumbers & ";"
Click to expand...

Providing that there is a line of code you didn't post that sets the value
of strReceiptNumbers to a numeric value and another line of code that
executes strTendSaleSQL as a SQL statement, then I see nothing wrong with
what you have.
 
Top