How can I use number of records in a layout, as a

[Ed Holland]

How can I use number of records in a layout, as a part of a caculation. I tried setting a summary feild in the layout to reference, but it only counts the found set, I cannot force a find all from the calculation menu. Thanks for any help, Ed

[comment]

There are no records in a layout. If you mean the total number records in the current table, use the Get(TotalRecordCount) function.

[Ed Holland]

Thanks, that's going to work.

Is there a way to specify which table to get the record count from?

[comment]

If it is used in a calculation field, it will return the total number records in the table in which the field is defined. To reference the total number records in another table, you can define the field there and then refer to it - same as any other related field.

If it is used in a script, it will return the total number records in the table of the current layout.

[Ed Holland]

Thankyou, for your time and help

Ed