On Tue, 14 Dec 2004 00:37:33 GMT, "David Seeto via AccessMonster.com"
<fo***@AccessMonster.com> wrote:
What's the structure of the tables in question? You should be able to create a UNION query to append otgether the output from several tables and then build your report on that...
First, what is a union query?? Second of all, I have no idea how to
write any code for Access. All I know about is relationships.
Databases consist of multiple student tables. Primary table is
tbl_student_info and consists of field for last name, first name, and
the key is their SS number.
All other tables are linked using the key/SSN. For instance,
tbl_AA/AS has a key identifier, with second table labeled StudentSSN
with a one-to-many relationship going from the key ID in the main
table to the StudentSSN in all other tables.
I want to pull info from any table with the StudentSSN relationship
into a query. For example, in a query to glean the status of the
students AA/AS, I need to
1) query tbl_student_info and tbl_AA/AS.
2) I want to generate a report showing the information in the query
combining information from both tables.
Is this even possible? I think if I can understand HOW to report info
from multiple sources, I will solve a major issue. I have never
written any code in my life for Access so I need to rely on queries
and reports to generate information. I have no problem editing and
moving around items to create the desired results. However, if this
is dependent on programming language, I am a very dead duck. I have
never taken a class in Access and reading it in a book makes no sense
in any of the books I have looked at. I am stupid, dumb, iggerint
about programming. If it MUST have programming, then I cannot do it.
Does this help at all?
Thanks!