Dsum data between to dates for this year and last year

[sdel_nevo]

Hi Guys



i have a form that sums up all the payments from the account transactions table based on an category ID between the dates entered on a form called profit and loss

the code below is what's used

=Nz(DSum("[payment]","[Account Transactions]","[category]=1 and [Entry Date] between #" & Format([Forms]![Open Profit And Loss]![Start Date Txt Box],"mm\/dd\/yyyy") & "# And #" & Format([Forms]![Open Profit And Loss]![End Date Txt Box],"mm\/dd\/yyyy") & "#"),0)

this works really well, many thanks to everyone who has helped me over the last few months

i would like to be able to show on the same form in a unbound text box exactly the same but for last year, i am not sure how i can enter year(now())-1 into the code above, or even if this is the correct way to go.

any help would be most gratefully received.

[sdel_nevo]

god, not sure why i didn't see this earlier

i just added 2 more date fields to the [Open Profit And Loss] form, that = start date-365 and end date -365 and referenced them in the code.

Steve