Display Found Set of records

[Gary Weisbrodt]

What is the easiest way to display the number of records found out of number of records on a layout?

Found: 56

Total: 6,789

[Ugo DI LUCA]

Hi,

Here's what I currently use, hoping my functions get translated correctly.

Get(TotalRecordsFound) & " record" & Case(Get(TotalRecordsFound > 1;"s ";" ") & "Found"& Case(Get(TotalRecordsFound > 1;"s ";" ") & "on a total " & Choose(Get(Sort);"unsorted";"sorted";"semi-sorted") & " of " & Get(TotalRecordsCount)

[MoonShadow]

Since you have Developer 7, you might want to consider creating a Custom Function out of it, regardless of what calculation you decide upon. You would need no parameters. CF I use (stolen from a post here on forums by Ray Cologon) displays a bit more ...

Custom Function Name: Records Bar =

"Record " &

TextStyleAdd(Get(RecordNumber); Bold) &

" of " &

TextStyleAdd(Get(FoundCount); Bold) &

If(Get(FoundCount) < Get(TotalRecordCount);

Left(" Records"; 7 + (Get(FoundCount) > 1)) & "