Next record navigation

[jrob10]

Hi, just wondering if there is a way to pull the 'next' record out of a column in a table? I have tried using the 'NEXT(fld)' function but it's not returning the right data. I am trying to skip over a 'NULL' value in the column to actual data. Am I missing something here?

Thanks for your help in advance.

 

[lbass]

You can't really "skip" a null. Do you have the option of eliminating nulls from your report altogether? You could use a record select like:

not isnull({table.field})

Then the next function would work. If you can't eliminate nulls, then provide a description of what you are trying to do, along with some sample data, so we can determine what alternatives there might be.

-LB