PC Review


Reply
Thread Tools Rate Thread

Re: Reading Previous record of field and inserting it into current If Is Null??

 
 
Bob Barrows
Guest
Posts: n/a
 
      19th Mar 2012
Perhaps:
UPDATE tbltest as o
SET Planned =
(
Select Planned FROM tbltest
WHERE keyfield=
(
SELECT max(keyfield) FROM tbltest
WHERE Planned is not null and keyfield<o.keyfield
)
)
WHERE Planned Is Null

likeyeah wrote:
> Been having a play with a recordset method of doing this, practicing
> with a test table. The code below picks up when it is null or not,
> but getting errors trying to put in the previous value into the
> current record, then moving on again.
>
> Also will need error trapping in case the first record is null..
>
> J
>

<snip>


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to copy a value from a previous record into the current record Rex Microsoft Access 2 5th Oct 2006 02:29 PM
Current Record and Previous Record =?Utf-8?B?SGFuc2ZvcmQgY29ybmV0dA==?= Microsoft Access Forms 1 31st Mar 2006 09:37 PM
current record and previous record =?Utf-8?B?SGFuc2ZvcmQgY29ybmV0dA==?= Microsoft Access Forms 2 22nd Mar 2006 03:28 PM
Current Record Count, Previous Record #, Add New Record =?Utf-8?B?Um9iZXJ0IE51c3ogQCBEUFM=?= Microsoft Access Forms 0 15th Feb 2005 09:35 PM
How to get the value in previous record to current record? Praveen Manne Microsoft Access 4 21st Jun 2004 09:54 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:03 PM.