obtaining data for a report

[Ted N]

I have no programing background and I'm trying to do something that
should be relatively simple but it is beyond me even after consulting
several books.

A former collegue wrote a module that allows us to view a students
complete academic history on one sheet of paper. It was great,
however, he is now gone and our school system has changed from an AS/
400 system to a
different system and our previous method of popoulating the fields in
our Access Database is no longer available.

I am trying to adjust the module he created to accept the new field
names. This part was relatively simple as I renamed the fields when I
imported them to Access from Excel. Unfortunately, in order for one
of the tables to be created, the subroutine within the module was
quite extensive because it had to do a lot of sorting that is no
longer necessary and returns errors when it runs. I can now get the
information presorted in an Excel spreadsheet so I only need to print
the data that is already there once it is imported to Access.
Unfortunately, I don't know how to separate the baby from the bath-
water. What I believe I need to do is remove the current FCAT
subroutine that has a lot of extreaneous code in it with a routine
that will go to the FCAT table, grab the data, and print it out on the
report.

The table I am using is called Best FCAT

The fields are

Field 1 = Student Number, (district assigned number)
Field 2 = Student Name
Field 3= Math (student math Score)
Field 4= Read (student read Score)

I would like to place it all on one line on a form with cells going
straight across to read:

Cell 1 Cell 2 Cell 3
FCAT Math: (score) Read: (Score)

(The placing of the Student Name and Number is already accomplished
with a previous subroutine within this module)

Everything is contained in the one Access database and I do not have
to link to tables outside of the database.

The module itself is tried and true, it pulls from 3 different tables
and gives us a report that is very functional. I hate to lose all
that formating.

So, how do I grab the data from the Access Table and print it on my
report?

Thank you in advance for your suggestions.

 

[Jeff Boyce]

This sounds like a previous post on the same topic.

Have you tried creating a query first? If you can get a query to return the
(raw) data you'll want on your report, you can then build your report to
display it as you desire.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Ted N]

I did, out of ignorance, post this same question on the "forms" board
but after being informed that the "report" board would have been more
appropriate I took the hint.

The Graduation Worksheet has 5 sections on 1 page and pulls data from
3 different tables:

1st section: Student Identification
2nd Section: FCAT data
3rd Section: Course History
4th Section: Grade Point Average
5th Section: Current Schedule

I can create a query, I can create a report that has everybodies FCAT
data, I can separate that report so that it is one FCAT line per
page. What I can't do, and need help on, is placing that data in the
correct place in the Graduation Worksheet so I can see all of Jane
Doe's information in one place.

Ted N.

 

[Jeff Boyce]

Ted

Perhaps you can create multiple queries (and multiple reports) that each
gather a piece of a student's data from the underlying tables (if you can't
create a query that gathers ALL of it in one place).

Then you could create an empty report (not bound to any query) and use the
above reports as subreports. This seems like it could show "all of Jane
Doe's information in one place".

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

I did, out of ignorance, post this same question on the "forms" board
but after being informed that the "report" board would have been more
appropriate I took the hint.

The Graduation Worksheet has 5 sections on 1 page and pulls data from
3 different tables:

1st section: Student Identification
2nd Section: FCAT data
3rd Section: Course History
4th Section: Grade Point Average
5th Section: Current Schedule

I can create a query, I can create a report that has everybodies FCAT
data, I can separate that report so that it is one FCAT line per
page. What I can't do, and need help on, is placing that data in the
correct place in the Graduation Worksheet so I can see all of Jane
Doe's information in one place.

Ted N.