I can think of a couple of other ways to do this.  What other fields are in your Access table? 

For example, is there a field that identifies the Pilot?  If there is, then I'll recommend one way to do this, if there's not, you'll have to take a slightly more complicated route.

-Dell

If you can add that field, then here's how to get your report.

1.  In the Database Expert, add additional copies of your table.  Crystal will give you a message asking if you want to alias them - click on Yes.  You'll see the table name with "_1", "_2", etc.  You want a copy of the table for each of your timeframes.  So, assuming the table is named Flight_Info, you would have the following:

Flight_Info - used for the Daily Block
Flight_Info_1 - used for the 7Day Block
Flight_Info_2 - used for the 30Day Block
Flight_Info_3 - used for the 365Day Block

2.  Link from Flight_Info to each of the other tables on the Pilot field.  DO NOT link consecutively - e.g. from _1 to _2 to _3.  All links must originate from Flight_Info.

3.  Create 3 formulas - 1 for each timeframe.  For example:

{@7Days} is {Flight_info.Flight Date} - 7

4.  In the Select Expert, select the field {Flight_Info_1.Flight Date} Is Greater Than or Equal To {@7Days}.  Do the same for the _2 >= {@30Days} and _3 >= {@365Days}.  Add these lines to whatever you're already doing to get the specific flight date.  You may have to tweak this to exclude dates that are after the flight date you're looking at from the Flight_Info table.

5.  Group on Pilot.  Place your column names in the group header section.

6.  Suppress the details section.

You  need to create an Index on the Pilot field in your database......Sorry about that, it's been years since I've worked in file-based databases, most of what I'm doing these days is in Oracle and MS SQL Server where there is no index requirement for linking tables.

The alternative is to create a sub-report for each flight block after the Daily one. 

Try just