no idea where to go or what to do

[RangerTen]

I have been pondering this for a long time and still have no idea where to go. I have an access database that performs several calculations when I print the report (happens during the detail format event). These calculations are relatively complex and happen through a series of if/then/else statements. I now want to increase the capabilities of this program by creating a chart from my results. However, the numbers I want to use for the series are only figured through the format detail of the report. I only know the chart object to take its data from a table, and I can't figure out how to get the report data into a table. I don't have any idea what I should do at this point. I don't think I can have a calculated control that does this whole series of if/then/else (or I don't know how). Should I do the calculations and then write it to an array, and then put the array into a table (of course, I don't know how to do that either).

How do I make a calculation and then store that in a table so that I can create a chart out of it...any ideas would be greatly appreciated. Right now I don't necessarily need the coding. I just need the proper ideas or ways to accomplish something like this. I'm just stumped and would sincerely appreciate anything you can provide. Where can I go with this?

-Pete

 

[RangerTen]

Is it possible to do "complicated" if then else calculations in a query? That would probably be the easiest for me to do. Not too familiar with creating new recordsets in access

Thanks for the help.

-Pete

 

[Mile-O]

You can use the IIf() function in a query which is basically a way of saying IF...THEN...ELSE

i.e

IIf(condition, then, else)

So:

MyNewField: IIf([MyName] = "John", 0, 1)

To do them complicated, you can nest the IIf() function.

MyNewField: IIf([MyName] = "John", 0, IIf([MyName] = "James", 1, 2))

 

[RangerTen]

Thank you very much. That helps a great deal.