Data display question

[adamwashere]

Hi all,

I work with the Clinton Foundation and I have a question about displaying data. We have an Access database in which many statistics have been compiled for many countries from many publications. We'd like to create an output that gives the user an option to display multiple statistics for multiple countries by selecting the desired statistics and countries from lists.

Is this easily possible? If so, what is the best way to implement this function? Thanks for your time.

Adam

 

[fneily]

New to Access? You answered your own question. You can have a form with an option box to select the desired report, or combo or list box to select the criteria. It's up to your creativity. Is it mostly demographical statistics - counts? Create queries to calculate them. If you have to do Poisson distributions and such you'll probably have to import the data to Excel first.
You ask, "Is this easily possible?" What's your skill level of math and programming?

 

[adamwashere]

Thanks for the reply fneily.

I am new to Access - started last week - but I've got a relatively strong background in math and programming. The reason I finally resorted to forums for help is that the Access books in our office, online help manuals, etc. give solutions to very similar problems, but not ours exactly.

I haven't found an example program with multiple combo or list boxes that allow the output of multiple records (and selectable fields within these records). I know this is relatively simple task (we're basically just looking for a pivot table with countries on one axis and statistics on the other) but our office hasn't been able to come up with a solution yet.

Luckily, we don't need to do any calculations or distributions. We'd just like to make specific, selectable sections of a large amount of data readily available.