Should be simple

[tedofocala]

but I can't figure it out.

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

A former collegue wrote a program 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 to a
different reporting system. I am trying to adjust his program to
accept the new field names. His old program had to do a lot of
sorting to get the basic information that we need. Fortunately, I can
get the basic information without the need for all the extreaneous
code. Unfortunately I don't know how to separate the baby from the
bath-water. Basically, what I need to do is...

Get the information from Access onto my report.

The table I am using is called Best FCAT

The fields are Student Number, StuName, Math, Read

StuNumber = district assigned number
StuName = Student full name
Math = students score in math (three digit numeric)
Read = students score in Reading (three digit numeric)

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 the original program.)


Any assistance would be greatly appreciated.

Ted N.
Ocala, FL

 

[Jeff Boyce]

You don't mention whether you are using Access or something else (?what?).

You don't mention whether you have Access.

One way to get data out of Access is to link to the database from (?).

If that other application can't link to Access tables, another way would be
to use Access and export the data into something that could be used, for
example, into Excel.

More specific description may lead to more specific suggestions.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


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

 

[tedofocala]

Jeff:

I should have mentioned that this was an Access database. I made the
poor assumption that since this was an Access forum it was a given
that I was talking about Access.

This is an Access module, it pulls all the data from the opened Access
database. There are no links to external tables. I am able to import
all the data I need from Excel to the Access database that contains
this module. I have successfully renamed the fields for other aspects
of the program so that most of the "Graduation Worksheet" displays all
the data. However, this portion is alluding me because there is so
much extra code that was needed at the time but is not currently
needed because I can import the raw data directly into Access from
Excel.

Ted

 

[Jeff Boyce]

Ted

Probably was my confusion with the description "change to a different
reporting system" and "get the information from Access onto my report"...
(Note that you've posted in a "forms"-related newsgroup, not a "reports"
'group.)

There are two ways to "pull ... data from [an] Access database". One is
using imported tables (data in the same .mdb file as the module) and one is
to link to the data in another Access .mdb file. You mention importing data
from Excel ... is that imported into the old Access database or the new one?

It all starts with the data...

If I were trying to build a report I would first build a query that returns
the data I wanted to print out. When that was working, I'd create a new
report that laid out the data in the format I wanted to see. I (probably)
wouldn't (need to) resort to modules (yet another newsgroup!) unless the
data structure was particularly un-normalized.

Access' relationally-oriented features/functions presume the underlying data
is well-normalized. If your application only imports Excel data directly,
without parsing it into a normalized (permanent) table structure in Access,
you may be trying to do relational things with 'sheet data ... that will be
a lot of work, good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


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


Jeff:

I should have mentioned that this was an Access database. I made the
poor assumption that since this was an Access forum it was a given
that I was talking about Access.

This is an Access module, it pulls all the data from the opened Access
database. There are no links to external tables. I am able to import
all the data I need from Excel to the Access database that contains
this module. I have successfully renamed the fields for other aspects
of the program so that most of the "Graduation Worksheet" displays all
the data. However, this portion is alluding me because there is so
much extra code that was needed at the time but is not currently
needed because I can import the raw data directly into Access from
Excel.

Ted

 

[tedofocala]

Now I know the difference between a report and a form.

Full story:

The original program we used for our Grade History was an AS/400
system. The tesing data reported under that system included a lot of
information that had to be "filtered out". I am now able to get only
the information I need for my report in an Excel spreadsheet and I
import this information into my Access Database.

I created an Access database I named "Graduation Work Sheet" . To
keep things simple, that data base contains all the information I need
for the Graduation Work Sheet (GWS) and only the information for the
graduation worksheet.

The worksheet contains several sections and Access must pull data from
5 different tables to complete the worksheet. I assume that this is
why the original creator used a module.

By renaming fields as I import them from Excel, I was able to get the
data onto (into) 4 out of 5 sections correctly. But becasue the
subroutine that contains the test data is so convoluted, I can't see
my way through it. I have created a report that shows the test data
exactly how I want it on the GWS. It is just frustrating me that I
can't figure out how to get it from there to the GWS.

Ted

Ted

Probably was my confusion with the description "change to a different
reporting system" and "get the information from Access onto my report"...
(Note that you've posted in a "forms"-related newsgroup, not a "reports"
'group.)

There are two ways to "pull ... data from [an] Access database".  One is
using imported tables (data in the same .mdb file as the module) and one is
to link to the data in another Access .mdb file.  You mention importing data
from Excel ... is that imported into the old Access database or the new one?

It all starts with the data...

If I were trying to build a report I would first build a query that returns
the data I wanted to print out.  When that was working, I'd create a new
report that laid out the data in the format I wanted to see.  I (probably)
wouldn't (need to) resort to modules (yet another newsgroup!) unless the
data structure was particularly un-normalized.

Access' relationally-oriented features/functions presume the underlying data
is well-normalized.  If your application only imports Excel data directly,
without parsing it into a normalized (permanent) table structure in Access,
you may be trying to do relational things with 'sheet data ... that will be
a lot of work, good luck!

--
Regards

Jeff Boycewww.InformationFutures.net

Microsoft Office/Access MVPhttp://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentorhttp://microsoftitacademy.com/


Jeff:

I should have mentioned that this was an Access database.  I made the
poor assumption that since this was an Access forum it was a given
that I was talking about Access.

This is an Access module, it pulls all the data from the opened Access
database.  There are no links to external tables.  I am able to import
all the data I need from Excel to the Access database that contains
this module.  I have successfully renamed the fields for other aspects
of the program so that most of the "Graduation Worksheet" displays all
the data.  However, this portion is alluding me because there is so
much extra code that was needed at the time but is not currently
needed because I can import the raw data directly into Access from
Excel.

Ted

You don't mention whether you are using Access or something else (?what?).

You don't mention whether you have Access.

One way to get data out of Access is to link to the database from (?).

If that other application can't link to Access tables, another way would be
to use Access and export the data into something that could be used, for
example, into Excel.

More specific description may lead to more specific suggestions.
Jeff Boycewww.InformationFutures.net

Microsoft Office/Access MVPhttp://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentorhttp://microsoftitacademy.com/

- Show quoted text -- Hide quoted text -

- Show quoted text -