Get Total Amount for Year To Date

[Happy2]

Hi all,

Can anyone please help me to sum up all the year-to-date amounts of a spicific employee.
I would like to show the YTD amount on my form and report.

Thanks in advance for your help.

 

[judiew]

You could use Select sum(amount) from tbl_a where employee# = employee_Specified. You can include a test for the year if there is more than this years data in the database.

I you needed the totals for all you can add a group by.

hope this helps....
judie