I have a simple report that is being used to verify tax setup.   The core tax information is held in a couple of tables but the tax rate is stored in a '1 to many' table with effective date for historical purposes ( 1 tax can have many tax rate/effdate combinations) .

I am using a subreport to pull the tax rate information and currently it lists all the tax rates/effdate records for a particular tax.  I am only interested in the newest record.

The report is using tables and not procedures, how do i limit the data returned to the newest record ?

thanks in advance

The 'newest' record does not have the same date between different tax types.  CA sales tax for instance was just changed in April, but Nevada hasn't changed in eons.  So there is no real criteria i can look for other than that the record is the newest of the set.

Thanks all for the ideas, I'll give this a try and let ya know.  I appreciate your efforts !!