How to make limitation in report chart??

[Fekri]

Hi,

I want to make limitation in my report chart to view just the value more than 5%, because below 5% in 3D circullar chart the value name will be unreadable!!.

thanks for any help
A. Fekri

 

[dhookom]

Change the Row Source query to eliminate the records you don't want to see.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Fekri]

You are right,

but I don't how to filter as percent in my row source query??

my rowsource query is this:

SELECT [Tafzili Detail].[Tafzili Description], Sum(tempview.[24]) AS SumOf24 FROM tempview INNER JOIN [Tafzili Detail] ON tempview.[2] = [Tafzili Detail].[Tafzili Code] GROUP BY [Tafzili Detail].[Tafzili Description];

but how to limit [24] which is currency and not percentage?

thanks for your advise
fekri

 

[dhookom]

Try something like

SELECT [Tafzili Detail].[Tafzili Description], 
Sum(tempview.[24]) AS SumOf24 
FROM tempview INNER JOIN [Tafzili Detail] ON 
tempview.[2] = [Tafzili Detail].[Tafzili Code] 
GROUP BY [Tafzili Detail].[Tafzili Description]
HAVING Sum(tempview.[24])/
(SELECT Sum(tempview.[24]) 
FROM tempview INNER JOIN [Tafzili Detail] ON 
tempview.[2] = [Tafzili Detail].[Tafzili Code]) >0.04 
;

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]