http://gamingtrend.com
August 28, 2014, 03:35:43 AM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News:
 
   Home   Help Search Calendar Login Register  
Pages: [1]   Go Down
  Print  
Author Topic: Access 2000  (Read 1078 times)
0 Members and 1 Guest are viewing this topic.
draegun
Gaming Trend Reader

Offline Offline

Posts: 58


View Profile
« on: October 29, 2004, 03:33:49 PM »

I have a query updating a table from another table.  Sometimes the fields updating are populated with info, while other times they are blank.  I want to keep the populated info even when the updating info is blank.

How do I do this???  Thanks for any and all help.
Logged
Biyobi
Gaming Trend Senior Member

Offline Offline

Posts: 718


View Profile
« Reply #1 on: October 29, 2004, 07:31:22 PM »

You should be able to add an IF statement saying to only update a field if the "new" information is NOT null (i.e., it has new data).  I haven't played with Access in a year or so but something to that effect should be possible.
Logged
draegun
Gaming Trend Reader

Offline Offline

Posts: 58


View Profile
« Reply #2 on: November 01, 2004, 08:04:22 PM »

Beautiful.  Had someone help with the IIF script? and it worked like a charm.

thanks.
Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2013, Simple Machines
Valid XHTML 1.0! Valid CSS!
Page created in 0.086 seconds with 28 queries. (Pretty URLs adds 0.021s, 2q)