doing report in access

  • Thread starter Thread starter Stud_access
  • Start date Start date
S

Stud_access

Guest
i need help I have a report that will show comp id, prev yr, current yr..
Under prev yr and current yr are the values . But for some reason the prev yrs values is not showing properly.

Supposed to be the values should be the values under each yr.. See under Year-1, the values is showing but on my access report the values showing under Year-1(2003) is the same as the values under Year(2004)..

What is the problem here..
I attched my access file, report name table1

i really need help plz...
 

Attachments

Last edited:
the criteria i would use to display the previous year value would be

Year([yourField])=Year(Now())-1
 

Users who are viewing this thread

Back
Top Bottom