|  | Creating a report with calculated fields | | |
| | | HopyMSU |  |
|  Posted: Fri Aug 22, 2008 6:34 pm Post subject: Creating a report with calculated fields |  |
| |  | |
Hi all,
I am a teacher and I'm trying to get Access to do something that I
found very easy in FileMaker. I know it can be done with Access, just
not exactly sure how. Basically, I have a table with student names
and an instrument that they play. I want to generate a report that
will list the students' names in alphabetical order underneath a
heading of the instrument that they play AND display a count next to
the header.
It all needs to be "dynamic" ... for example, the report will have to
grow/shrink for each section, but also each instrumental section needs
to be pre-sorted so it is in a non-alphabetical order down the page.
It would look like this:
Flute (3)
<<FNAME>> <<LNAME>>
<<FNAME>> <<LNAME>>
<<FNAME>> <<LNAME>>
Clarinet (1)
<<FNAME>> <<LNAME>>
Alto Saxophone (2)
<<FNAME>> <<LNAME>>
<<FNAME>> <<LNAME>>
So... here are the specific questions:
1. How can I sort the instruments so that they are in "score
order" (Flute - clarinet - saxophone - trumpet - trombone ... etc.)?
2. How do I do a count of the number of kids in each section
3. How can I set up a report (or a query for that matter) that lists
the name of the instrument and displays student names below it?
Hope you all can help - thanks!
Andy |
| |
| | | KARL DEWEY | |
| | Posted: Fri Aug 22, 2008 6:34 pm Post subject: RE: Creating a report with calculated fields | |
| | | |
Add a field named Sort, using numerials to designate which is first, second,
third, etc.
In report design view click on Group and Sort, select the Sort field and
then add names.
In the Sort header put the instrument field. Add text box and for source
use =Count[LNAME])
--
KARL DEWEY
Build a little - Test a little
"HopyMSU" wrote:
| Quote: | Hi all,
I am a teacher and I'm trying to get Access to do something that I
found very easy in FileMaker. I know it can be done with Access, just
not exactly sure how. Basically, I have a table with student names
and an instrument that they play. I want to generate a report that
will list the students' names in alphabetical order underneath a
heading of the instrument that they play AND display a count next to
the header.
It all needs to be "dynamic" ... for example, the report will have to
grow/shrink for each section, but also each instrumental section needs
to be pre-sorted so it is in a non-alphabetical order down the page.
It would look like this:
Flute (3)
FNAME>> <<LNAME
FNAME>> <<LNAME
FNAME>> <<LNAME
Clarinet (1)
FNAME>> <<LNAME
Alto Saxophone (2)
FNAME>> <<LNAME
FNAME>> <<LNAME
So... here are the specific questions:
1. How can I sort the instruments so that they are in "score
order" (Flute - clarinet - saxophone - trumpet - trombone ... etc.)?
2. How do I do a count of the number of kids in each section
3. How can I set up a report (or a query for that matter) that lists
the name of the instrument and displays student names below it?
Hope you all can help - thanks!
Andy
|
|
| |
| | | HopyMSU | |
| | Posted: Fri Aug 22, 2008 7:12 pm Post subject: Re: Creating a report with calculated fields | |
I should mention... I'm using Access 2007.
A |
| |
| | | HopyMSU | |
| | Posted: Sun Aug 24, 2008 2:48 am Post subject: Re: Creating a report with calculated fields | |
Karl,
Thanks. I've got it now so it counts the total; but it only displays
one instrument and name... now how do I get it to show ALL names AND
each instrument (with names)? Does it have something to do with
grouping?
Karl,
Thanks. I've got it now so it counts the total; but it only displays
one instrument and name... now how do I get it to show ALL names AND
each instrument (with names)? Does it have something to do with
grouping?
A
On Aug 22, 4:07 pm, KARL DEWEY <KARLDE...@discussions.microsoft.com>
wrote:
| Quote: | Add a field named Sort, using numerials to designate which is first, second,
third, etc.
In report design view click on Group and Sort, select the Sort field and
then add names.
In the Sort header put the instrument field. Add text box and for source
use =Count[LNAME])
--
KARL DEWEY
Build a little - Test a little
|
|
| |
|
|
