AboutJamey Key Expertise NEW and INTERMEDIATE USERS. WHAT CAN FILEMAKER PRO DO FOR ME? I have been using FileMaker products for over 10 years and have basic knowledge in all areas of FileMaker database set up and use. I`m not prepared to answer questions about complex situations or calculations but can help beginners and intermediate users set up and use FileMaker databases.
Experience Have been using FileMaker since 1989 in our business. We have 10 users on the network who use these databases every day. Our largest databases have had over 30,000 records at one time. In 1995 one of my files was chosen as "Most Unique Database" in a contest sponsored by Claris, maker of FileMaker. Recently I have developed a set of files for new computer system installed at our church.
I have a FileMaker database that is used by my organization to store revenue broken down by week. However, there are instances in which 2 months can fall in the same week (i.e. December 31st and January 1).
Is there a way to create a calculation which sums up a field if it falls into a date range specified.
If so, please let me know how I can do this.
Thanks,
Chris
Answer Chris;
Im not sure what you are wanting to do. Are you wanting Dec. 31 and Jan. 1 to be in different weeks even if they are in the same week? Give me a little more clarification and I will help you figure it out.
