<div>
<div class="content wysiwyg-content">
I am using the below code to pull up current year. How can I modify it so that it pulls up last year?<br />
<br />
GROUP BY &quot;ADAY&quot;, Format(Nz([qryFirstDayReve<wbr />nueBooked]<wbr />.[FirstDay<wbr />],#1/1/195<wbr />0#),&quot;yyyy&quot;<wbr />)<br />
HAVING (((Format(Nz([qryFirstDayR<wbr />evenueBook<wbr />ed].[First<wbr />Day],#1/1/<wbr />1950#),&quot;yy<wbr />yy&quot;))=Form<wbr />at(Now(),&quot;<wbr />yyyy&quot;)));
</div>
</div>


I am using the below code to pull up current year. How can I modify it so that it pulls up last year?

GROUP BY "ADAY", Format(Nz([qryFirstDayRevenueBooked].[FirstDay],#1/1/1950#),"yyyy")
HAVING (((Format(Nz([qryFirstDayRevenueBooked].[FirstDay],#1/1/1950#),"yyyy"))=Format(Now(),"yyyy")));

Formula for last year

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.