Max Records

[vbjohn]

I need to have a report that shows a max number of hours of 8500. If the number is more than 8500 then put that record at 8500 else print out the number.

I am creating a report in Visual Basic's Data Reporter with Sql as the backend.

This Sql does not support CASE Statements. Any help would be great.

 

[tlbroadbent]

Try creating a view in SQL Server and using that view as the datasource for the report. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.