Recent content by lj1602

Hello, It's difficult to work out exactly where you want the new field with the YTD value to show, however, just using the DSum statement from your post, the WHERE clause should read: "FiscalYear = " & [FiscalYearHere] & " AND SchoolNumber = " &...

Hi kakaooo I do tend to agree with wiklendt that you've got the principles the wrong way around, a subform should display details based on a main form selection. But, to achieve what you want the code below, used on an Enter event for the primary key field on the subform (assumed here to be...

Not sure you can achieve what you want within your table, but you could use a combination of a make table query and an append query to create a copy of your final product after the last update. You would then export the copy rather than the final product table. Create a copy of your final...