On the transcripts I am creating I need two specific dates on the top of the paper. Student Start Date, and then Student Graduation/Leave date. My problem is the report is putting the date ranges OF THAT PAGE, not of their entire term in our college.

I am unable to wrap my brain around the formula that will have the date range in it's entirety not just of the data on the page.

???

Hey Ryan!

I put two specific dates into the page header. One date was the day the student started with the school while the other was when the student graduates, or up to the current term they are enrolled. 

I pulled the Field name from the database field section. Every time I switch pages the date changes. This should not happen! This is a set date. What I think is happening is the start date is changes in relation to when they started the class listed on the page, and the end date is listed for the last class on that sheet in relation to the class listed.

I have no method. I have been trying to write a formula so that it will pull the first "entry" date and it will not change,  even when going from page to page. Also, I tried to write a formula for the end date to be permanent and the same from one page of the transcript to the next.

The grouping in the report are by last name, and the term. There are around three terms on a page. When I click to the next page the dates change in relation to those classes.

The outcome I want is basic, two dates to stay permanent on ever page of the specific student's transcripts. If they started on 05/16/2008 I want that field to stay 05/16/2008 throughout. 

Example: I put in the field and on one page the start date is 05/16/2008, next page it turns to 07/10/2008, next page it changes again. Like wise with the end date as well.

My concern is, when I open this data in excel, there is one date for each category,  a START DATE and an END DATE, not everything in between.

Does this help clarify? Thanks for the help!

I understand what you are saying, however I attempted this today and I was unable to make it work. What it is doing is picking the minimum date of 2000 sets of data, and a maximum date of 2000 sets of data, when I want it per student. 

So I go to the grouping button, pick minimum and maximum and start date and end date, where do I add the student? ex. Minimum(date,student) ???

I also attempted writing a formula for this as well in the formula editor and it says that my information is not part of the formula...