REQ: Field To Display TOTAL RECORDS

[JCJXXL]

I know the total number of records is listed to the left in the tool palette. But is there a field I could use to show the total record count? Basically something that displays the total number of customers in the database?

Thanks.

[Fei]

Just add @@ at any where of your record.

[JCJXXL]

Hi Fei.

I tried your suggestion and it displays the CURRENT record but not the TOTAL number of records.

On my layout I have the following:

Curent Customer Record (this displays the current record I am working on)

Total Customer Count (This is what I need.. something to show the total number of records in the database).

Thanks for your help :)

[Ender]

Define a calc:

RecordCount (calculation, number result) = get(foundcount)

In the Storage options, select "Do not store calculation results"

[Fei]

You can create a SUMMARY field and choose COUNT and point to any one of your field. In your case you can choose your customer name. It will calculate for u the total of customer.

[JCJXXL]

Ender, works perfect! Thank you! That has been a headache for me to figure out. Guess we all start off somehwere.

Thanks again!

[Ender]

While a Summary Count is good to have in many tables for various Sub-Summary reports, it is not an efficient way to get the found count. In large record sets, it is much slower to calculate such summary fields than it is to use the function designed for this purpose, get(foundcount).

[BobWeaver]

Also note the difference between Get(FoundCount) and Get(TotalRecordCount). The first gives the number of records in the found set, and the second gives the total number of records in the table.

[Fei]

Thanks for the tips. :)

[JCJXXL]

Good info guys!

Thanks.