Solved Filter report based on Group value (1 Viewer)

[mfaisal.ce]

Hi every one,

I have a report and i have a field Name "Balance". I want following conditions on group level
1. Balance =0
2. Balance >0
3. Balance <0

How can i do that? Plz guide....

regards,

 

[plog]

You would create a new field in the reports query and then group on that new field in your report. Your other thread shows you how to do that:

Solved - Assign Dummy Value in Query

Dears, i want to make a query with a criteria based on value of Field.... Table: Purchase Field. ID Field. Balance I want to make a query in such a way that 1. Balance =0, output 0 2. Balance >0,output 1 3.Balance

www.access-programmers.co.uk

 

[arnelgp]

On Grouping, select Expression and the Expression is:

Switch([Balance] = 0, 0, [Balance] >0, 1, [Balance] < 0, 2, True, 3)

 

[mfaisal.ce]

thanks a lot .... it worked....