Jump to content

Calculation to determine the last record


 Share

This topic is 6490 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello,

I would like to create a field that will 'know' if it is the last record. I have been posting with regard to using a database to generate HTML output for this application I need to know if a record is the last one so I cen generate the appropriate closing HTML tag.

Thanks,

Robert

FileMaker Version: 7

Platform: Mac OS X Panther

Link to comment
Share on other sites

Create a calculation field equal to Status(CurrentRecordNumber) = Status(CurrentFoundCount). This will return a 1 if it's the last record, otherwise zero.

Oh, and make sure it is unstored, otherwise the status functions will not update.

Link to comment
Share on other sites

Ahh thank you. I actually found a way to do it but it was more complicated than it had to be. I like this way better.

I was using a Summary field called Record_Number that took a running count of field Item_Name. Then I created a Calculation field Record_Number_Calc that was equal to Record_Number so as to make it available for use in another Summary field called Last_Record and defined as Maximum of Record_Number_Calc.

At least I can find back doors for doing things (most of the time, (lolol)

Robert

Link to comment
Share on other sites

This topic is 6490 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.