Home Forums Reporting Services Reporting Services Query to Select data from a single table with mutliple conditions RE: Query to Select data from a single table with mutliple conditions

  • February 28, 2013 at 9:37 am

    #1592050

    Hi Pete,

    Thanks for the reply.

    I figured it out by using it in this format.

    WHERE ([FTS Yearly Query].Dept = "3310" ) and ( ([FTS Yearly Query].Account >= 847000 and [FTS Yearly Query].Account <=847900 or [FTS Yearly Query].Account = 821000) and (Year([FTS Yearly Query].[Document Date])* 12 + DatePart("m", [FTS Yearly Query].[Document Date]) = Year(Date())* 12 + DatePart("m", Date()) - 1)

    Regards,

    Renato