iNcR3d1bl3 Posted March 25, 2006 Share Posted March 25, 2006 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. Link to comment Share on other sites More sharing options...
LaRetta Posted March 25, 2006 Share Posted March 25, 2006 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? Link to comment Share on other sites More sharing options...
iNcR3d1bl3 Posted March 26, 2006 Author Share Posted March 26, 2006 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 Link to comment Share on other sites More sharing options...
Raybaudi Posted March 26, 2006 Share Posted March 26, 2006 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 Link to comment Share on other sites More sharing options...
iNcR3d1bl3 Posted March 26, 2006 Author Share Posted March 26, 2006 Works like a charm, thanks for all your help :) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6579 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 accountSign in
Already have an account? Sign in here.
Sign In Now