how do I ...

  • Thread starter Thread starter JohnE
  • Start date Start date
J

JohnE

This could go in the report area but I'm just wanting to
discuss this topic. I did a report in Exel that the
higher ups would like to see duplicated in A2k. What
occurred was one of the tables was placed into Excel and
the summary worksheet made from there. I have duplicated
the summary worksheet in Access and getting the info to
fill in using an expression in each txtbox. The summary
is comprised of the following;
1) office listing down left side
2) each office has the same 5 categories going across
3) each of the 5 categories has a Yes, No, NA response
to it
4) each category has the total of yes's, no's, and NA's
5) each category has the percents of yes's and no's

Which makes a total of 75 txtboxes that are being utilized
to convey the summary information. As mentioned, getting
the numbers to fill in I've been able to do with an
expression in each txtbox. Except - it gathers the
numbers from the whole table.

What I need to do is set up a method so as to have a
parameter available for the user to select from. What the
summary should be able to show would be the following:
numbers by year by quarter
or numbers by year by month

This is where I'm in a quandry. How do I go about doing
something like that? Is there a sample that is available
to view to get ideas from? Am I way out there and going
about this the wrong way?
Thanks in advance to anyone who responds.
*** John
 
If you have duplicated the structure of your Excel spreadsheet in an
Access table, you are probably going to have troubles developing reports on
that data. You mention having textboxes with expressions for each item in
your report, this is certainly doing it the hard way. You really need to
approach the data from a different perspective (even rethinking what actual
values you are entering). In fact it is possible to create an Excel-like
set of data in Access by using a cross-tab query, this might be a first step
to getting what you want. Otherwise it might be worth re-examining why this
needs to be done in Access rather than Excel?

Doug
 
Back
Top