Multiple Time criteria

I have a database that records several times. I need to report on time
intervals for several points. I am using a select query to gather the data.
Several of the time intervals are variable. Example

Interval 1
Time2 - Time 1

interval 2
Time 6 - (time5 or time4) whichever is earliest

The criteria for interval 1 I have already, the expression for interval 2
has me a bit stymied. Any help is greatly appreciated.
.

Relevant Pages

  • Re: Creating Access DB
    ... database and in the SQL database that your report needs. ... click the query tab. ...
    (microsoft.public.excel.programming)
  • Re: String Used in Report Displays as Garbage
    ... Is there anything else in the database that has the name ProductCode? ... All the text in the calculated fields in my query are left aligned. ... I tried creating a new report with only the calculated field printed. ... You say the calculation looks fine in the query. ...
    (microsoft.public.access.reports)
  • RE: Database Search Facility
    ... I encountered your posts while researching a solution to my database ... I have had great results from the recommended Ad-Hoc Report! ... > What I specifically want to do is construct a main form with a subform. ... > in the main form and linking them to a query. ...
    (microsoft.public.access.formscoding)
  • Re: Genealogy database
    ... site design (a back end database with a web page user interface) and Access ... I can now do a Query to search (eg Surname ... Taylor) and produce a Report to show the results. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Suggestion
    ... Datamarts allow you to create summarized data and improve the query response ... You have to choose the better source regarding the report you have to ... Detailed information can query your OLTP data sources. ... >> Keeping the historical vs. current data partitioned by database is ...
    (microsoft.public.sqlserver.datawarehouse)