Showing # of new records

[iNcR3d1bl3]

Hi!

I'm fairly new to filemaker and I was wondering how I could show the # of total new records. I am already showing the total of all the records but I need to show the # of newest records. How do I go about accomplishing this?

Any help appreciated, thanks.

[LaRetta]

How would you like the records displayed? In a portal on a Main Menu for instance? And what is considered 'the newest?' Any created the same day they are viewed? Are these related records you want displayed in Parent? Or are they the records created in the same table you will be viewing them from?

[iNcR3d1bl3]

Hi,

I would like them to be displayed as a # in a main menu, the newest is considered of that day, and they are in same table

thanks

[Raybaudi]

Hi

you have to create 3 fields:

CreationDate = a date field with option of auto-enter the creation date

Flag = UNSTORED calculation field, result number and calc:

Case(

Get ( CurrentDate ) = CreationDate;1;

0

)

ToDayRecords = summary field = Total of Flag

[iNcR3d1bl3]

Works like a charm, thanks for all your help :)