Min and Max Records

[strom99]

I have the following data:

Tool Nbr
Run Nbr
Roll Nbr
Datetime
Yield

There are multiple Runs and Rolls per tool number, I need to display only the Min date and max date associated with each tool number. How could I accomplish this? Data is from SQL Server 2000, BO 5.1.7

Thanks

 

[BrianTyler]

There are several likely solutions:

In pure BO, the best way may be to have two data providers with a 'calculation' in each query (if you can understand the wizard thingy).

You could 'union' two queries.

You could use freehand SQL.

There could be a solution using an alias and joining the table to itself, but that may be messy

 

[blom0344]

I'd say that are 3 unlikely and one obvious solution

A union query with resp. a min(date) and then a max(date) is all you need

T. Blom
Information analyst
tbl@shimano-eu.com