Can you have 2 years of information in one query, or do you have to do two seperate queries and then join them?
???
There is no such restriction. However in the case you have seperate tables that contain data for each year you may need to build a union. However, I suspect you are asking this for a more specific reason.
So, please elaborate ;D
Well, how I was taught from my predecessor was if I wanted to show two years for the same attribute I needed to have two queries, one for the current year, and one for the previous year. This seems quite arduous, and I feel that I should be able to create a data item that somehow says "Current Year to date actual" and another item that says "Prior year to date actual." I figure that if I can easily do that in any other system why not this?
All numbers that I want to pull are on the same table.
Hi,
If you are retrieving your Current Year/Previous Year by using filters, could you simply code a filter that retrieves both (ie OR the two filters together) and retrieve the two periods in the same query?
MF.