The way I have my database set up, records are saved under a specific reporting date since that will never be duplicated. So, I have a field "Report Month" that I want to use in the report created by Access.
I would like the columns to be these report months so that I can do a quick comparison month-to-month and have it easier to see.
I also have a bunch of different fields in the various tables, so it'd be easier to have the report month be the column. How can I do this? I haven't been able to find any good resources, but it seems like it is possible.
I would like the columns to be these report months so that I can do a quick comparison month-to-month and have it easier to see.
I also have a bunch of different fields in the various tables, so it'd be easier to have the report month be the column. How can I do this? I haven't been able to find any good resources, but it seems like it is possible.