calcuation

[RET]

Ok I need a little help to figure out how I would set this calc

[Lee Smith]

Hi Ret,

Here is a simple file for you to look at.

Lee

[RET]

Somthing seem to be wrong with the server, I was unalbe to review your attachment.

RET

[-Queue-]

GetField( "Field" & GetField( "Field4" ) )

Even I am impressed that it works.

[RET]

Still don't get it ..can you elaborate?

[-Queue-]

GetField( "name" ) pulls the contents from the field specified in name. So GetField("Field4") retrieves whatever number is in Field4. Then you concatentate "Field" and this number to produce Field1, Field2, or Field3, depending upon what number was in Field4. Then you use GetField() again to retrieve the value from this resulting field.

See attachment for example.

Calc.zip

[Lee Smith]

Hi Queue,

Isn't Get Field a new feature found in Version 6 only? I have version 5.x, and it isn't there, not sure of as I didn't upgrade to 5.5.

Lee

[Lee Smith]

Hi Rit,

You are correct, there is something wrong with the server. I can send it to you direct if you want, just let me know what address.

Lee

[-Queue-]

Yes, it's in 5.5 My attachment works, but yours doesn't. Maybe try attaching it again?

[BobWeaver]

Or simply:

Field5 = Choose(Field4,Field1,Field2,Field3)

[-Queue-]

Choose( Field4 - 1, Field1, Field2, Field3 ), since zero is the first condition result.

[BobWeaver]

Oops.

[Lee Smith]

I was able to finally get the file to upload. Click Here

It is the enclosure in my 2nd to last posts.

Lee