Same query for 2 years

[mbrassfi]

Can you have 2 years of information in one query, or do you have to do two seperate queries and then join them?

[blom0344]

 ???

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

[mbrassfi]

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. 

[MFGF]

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.