View Single Post
  #4  
Old July 26th, 2016, 10:21 AM
tou tou is offline
Regular Contributor
 
Join Date: Oct 2015
Posts: 107
Default Re: Table / Copyfitting for 1 to 6 fields

You can always do it with more coding....:P

Assuming that when two fields are populate it's the first 2 location and so on....code it backwards...

if (Field("Location 6") != "") {
YOUR 6 LOCATION CODE GOES HERE
} else if (Field("Location 5") != "") {
YOUR 5 LOCATION CODE GOES HERE
} else if (Field("Location 4") != "") {
YOUR 4 LOCATION CODE GOES HERE
} else if (Field("Location 3") != "") {
YOUR 3 LOCATION CODE GOES HERE
} else if (Field("Location 2") != "") {
YOUR 2 LOCATION CODE GOES HERE
} else if (Field("Location 1") != "") {
YOUR 1 LOCATION CODE GOES HERE
}

If your locations are not always populated from 1 to 6 filled incrementally, you'll have to code more variables to handle it.

Good luck.
Reply With Quote