>old record example
>Sample# 1234567
>test1result 2.45
>test2result
>test3result 1.12
>..test55result 4.24
>
>I only want to copy where there is a value, either zero or a number.
Is testResult2 a character field or a numeric field? If it's a character field, then check ISBLANK(); if its numeric and NULL is a possible value, use ISNULL() to check for 'empty' values.
>I can't find a way to exclude test2 since it is blank. (There 55 result fields but usually only 5 - 10 have a value).
>new record layout
>Sample# Test# Result
>
>Something like
> Select 1
> IF !(ALLTRIM(STR(test1result)) = " ") then
> value = test1result
> select 2
> append blank
> replace sample# with samplevaraible
> replace test# with 5
> replace result with value
> ENDIF
>
>Thanks for any help.