Our Preferred 5 Star Hosting Provider - Award Winning FileMaker Pro Hosting
Results 1 to 2 of 2
  1. #1
    Forum Member
    Join Date
    Nov 2017
    Posts
    1
    Location
    Carterton, New Zealand
    FileMaker Pro Software
    FileMaker 16 Pro
    OS
    Mac
    Skill Level
    Novice
    Last Post
    11-27-2017
    Local Date
    12-11-2017
    Local Time
    03:16 PM
    Last Active
    11-27-2017

    Report on field using date range

    Hi,*



    I made a Filemaker Database a couple of years ago for a correspondence school, now I'm building the same thing for another school. The database has a record for each student and a field for each possible lesson they can be sent. When a lesson is sent the date goes in the appropriate field.



    For reporting I had no idea what I was doing, so I just made a table with a field for each lesson and a script that would search within a date range, take a record count of the returned records take that number and put it in my report table. The date range is set by global fields for the start date and the end date. The script would repeat for the 200 or so lessons that we had available. I would then have a report of the number of each lesson that was sent in a date range.*



    I guessing that there must be a better way, I have never used a summary report, is that something that would work? If someone could point me in the right direction I would be very very grateful.



    Thanks heaps in advance for any help or pointers. Using Filemaker 16.

  2. #2
    Senior Moderator - FMT Preferred Developer Consultant - New York - Worldwide AHunter3's Avatar
    Join Date
    Aug 2006
    Posts
    12,195
    Location
    New York and Nassau County, NY, USA
    FileMaker Pro Software
    FileMaker Advanced/Developer 14, 13, 12, 11, 10, 9. 8.8, 8, 7, 6, 5.5 FileMaker Pro 8, 7, 6, 5.5, 5
    OS
    Windows & Mac
    Skill Level
    Developer
    Last Post
    12-10-2017
    Local Date
    12-10-2017
    Local Time
    09:16 PM
    Last Active
    12-11-2017
    You need a table in which EACH instance of ONE student taking a SINGLE lesson constitutes a record. It will have a single date. That makes it easier to do reports on date ranges etc

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 01-05-2015, 08:41 PM
  2. Find a date range in a text field?
    By MrsWombat in forum FileMaker Pro 9
    Replies: 1
    Last Post: 11-03-2011, 03:52 PM
  3. Replies: 7
    Last Post: 11-04-2008, 06:41 PM
  4. Date Range for Report V9
    By JNGonzalez in forum FileMaker Pro 9
    Replies: 2
    Last Post: 01-10-2008, 04:42 AM
  5. Report summarising data in date range
    By angelfire4xx in forum FileMaker Pro 7.0
    Replies: 2
    Last Post: 08-01-2007, 05:18 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Welcome to the Original FileMaker Forum
With designated forums for almost every FileMaker topic...FileMaker Today is a FREE to join community where you can boost your FileMaker expertise, build better apps & solutions and interact with over 43,000+ FileMaker Developers from all over the world. If you're building FileMaker solutions, this is the place for you.
Follow FMT
We Are FMT
FMT is home of The World's leading FileMaker News Site, Worldwide Developer Directory, FileMaker Connect Community and so much more.