 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / May 2008Different destination fields
Hi All, I've got 2 fields in my database that represent Easting and Northings. Due to the way the client's db is set up, I need to append each of these values to one of 2 fields in the destination table (UTM_Easting or Grid_Easting). UTM's are the full 6/7 digits while Grid coordinates are usually 3 digits each. How would I build the query so that it would be able to determine if it should go to UTM_Easting or Grid_Easting? Thanks What about Len([YourField]) to separate by number of characters?  SignatureKARL DEWEY Build a little - Test a little > Hi All, > [quoted text clipped - 6 lines] > > Thanks I had gotten that far, but how do I tell it different destination fields? > What about Len([YourField]) to separate by number of characters? > [quoted text clipped - 8 lines] > > > > Thanks UpDate Yourtable SET Grid_Easting = IIF(Len([YourField])=3,[YourField[,[Grid_Easting]) , UTM_Easting = IIF(Len([YourField])>=6,[YourField],[UTM_Easting]) John Spencer Access MVP 2002-2005, 2007-2008 Center for Health Program Development and Management University of Maryland Baltimore County > I had gotten that far, but how do I tell it different destination fields? > [quoted text clipped - 10 lines] >>> >>> Thanks
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.