March 4, 200520 yr I have a calc time field repeating that I would like to omit in a find script. How would I omit all empty time results from say repeating 1?
March 4, 200520 yr If you know how do do a find, it is not that hard. Go into Find Mode Select the = in the pull down menu Check the box "Omit" Perform the Find HTH Lee
March 4, 200520 yr Find will not work if you want to omit records where repetition 1 is empty, but other repetitions may have values. You'll need a script: Show All Records Go to Record/Request/Page [ First ] Loop Exit Loop If [ not Get ( FoundCount ) ] If [ IsEmpty ( timefield ) ] Omit Record Else Go to Record/Request/Page [ Next; Exit after last ] End If End Loop
March 4, 200520 yr Since you specified a script, I suspect Lee's answer was not helpful to you. Could you be a bit more specific about the question, or try rewording it?
March 4, 200520 yr Alternately, you could create a calculation of timefield that is a single repetition, and perform your find in this field. Enter Find Mode [] Set Field [calctimefield; "="] Omit Record Perform Find [ ]
March 4, 200520 yr Oops, missed a couple of keywords in this one. That will teach me not to try and answer questions before finishing my first cup of coffee in the morning. Sorry, Lee
Create an account or sign in to comment