By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,192 Members | 1,276 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,192 IT Pros & Developers. It's quick & easy.

Can someone tell me what is wrong with this simple query syntax?

P: n/a
MLH
INSERT INTO tblCR ( Balance )
SELECT DISTINCTROW GetLastClientID() AS BigBalance
WHERE (([tblCR].[CR_Trans_No]=2));

I want to update the [Balance] field of tblCR in the unique
record in which tblCR's [CR_Trans_No] keyfield value is 2.

When trying to run this query, an error message tells me...
"Query input must contain at least one table or query"
I don't understand. How can I accomplish what I want to do?
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
MLH
Oops!
So sorry. I figured it out...

UPDATE DISTINCTROW tblCR SET tblCR.Balance = GetLastClientID()
WHERE ((tblCR.CR_Trans_No=2));

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.