iif and text options

[Guest]

For the last 10 months, I have gotten my of my answers from this great forum.
I hope I can do the same today.

I am trying to track how account applications originate (via phone, online,
etc) and show them as percentage over the total applications number. I would
like for the results to show on an Access form, preferably as a table or even
a pie chart.

Is there a way that this can be accomplished by using iif? My Access skills
are a bit rusty but I'm sure I'd be able to go a different route, if iif
won't work for this.

Thanks

 

[John Vinson]

For the last 10 months, I have gotten my of my answers from this great forum.
I hope I can do the same today.

I am trying to track how account applications originate (via phone, online,
etc) and show them as percentage over the total applications number. I would
like for the results to show on an Access form, preferably as a table or even
a pie chart.

Is there a way that this can be accomplished by using iif? My Access skills
are a bit rusty but I'm sure I'd be able to go a different route, if iif
won't work for this.

No IIF is needed. A Totals query would seem to be the ticket here. I
presume you have an Origination field in your table of applications;
you can create a Query based on the table, Group By application type,
and select Count on the primary key of the table.

You can then use the Chart wizard to create a chart (pie, bar,
whatever) displaying these counts.

John W. Vinson[MVP]