If your parameters are limiting the data retrieved to just the data between the two parameter dates, you can't get the YTD data from that table directly. If there's only one record per employee in the date range, it would be fairly easy to pull in a second copy of the table and set a filter on it for the current year's data. However, I suspect that you can have multiple records per employee for the date range, correct?
What type of database are you using? How familiar are you with SQL? There is a way to do this using a Command instead of the tables, but you need to know some SQL in order to be able to do this.
-Dell
IP Logged
