Hi,

  I got an DB which is having the data like name of the programm, Starting Data & End Date ...

 I want to generate the query using the year..
 like what are all the programm coducted from year 2003 to year 2006.. but the problem is iam entring the date, monthl & year in the table how can i get the report what expression should i put in the query..

 And another thing is If an programme stated on 30/12/2005 and ended on 3/1/2006 how the query will take if i give the years as 2004 to 2005 then i ill get that programm details ..but when i give 2006 to 2007 then the record wont appeare but the programme was happaned on the year 2006..

 Plz give me some solution ....if ur not able to understand please revert me...

 Expecting the reply..


Learn as you can..
------------------------
pap...

Hi,

   Crete your query, and then add a column with this as the source:

StartYear:(DatePart("yyyy", [StartDate]))

This column will report the following:

StartDate StartYear
30/12/2005 2005
3/1/2006 2006

So pass criteria to [StartYear] like "2005"

You can also add a column for EndYear using the same formula and pass criteria to it.

If you just pass criteria to the StartYear, this will give you programs that started in the scope of your query, regardless of when they ended.

Does that help?


mmcdonal

What about the question which i asked

 (And another thing is If an programme stated on 30/12/2005 and ended on 3/1/2006 how the query will take if i give the years as 2004 to 2005 then i ill get that programm details ..but when i give 2006 to 2007 then the record wont appeare but the programme was happaned on the year 2006..)

 Do u have any idea?


Learn as you can..
------------------------
pap...

As I said: "If you just pass criteria to the StartYear, this will give you programs that started in the scope of your query, regardless of when they ended."



mmcdonal