Finding empty time fields

[NickS]

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?

[Lee Smith]

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

[comment]

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

[bikergeek]

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?

[-Queue-]

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 [ ]

[Lee Smith]

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