473,327 Members | 1,930 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Two questions

I'm teaching a few classes at a summer camp and am building a database
on the kids taking the classes and the objectives in the class. I have
two questions though.

1. I have to periods of the same class and would like to join the two
tables together, I assume with a query, to make a report. The report
is seperated by troop number (ID number for where a kid is from) and
displays all the other information from the class. I would like it to
make one report rather than a seperate report for each of the two
classes. I tried making a query and joining two tables together by the
ID Number (The auto generated value) and it only puts the kids in the
first class in the query. How should it be done?

2. I have the report grouped by the troop number with a pagebreak
after everybody that is in the same troop number. How do I add the
title and footer to each page so it shows the same title on each page
and so forth?

Thanks,

Matt

Jun 26 '06 #1
4 1070
1. Put a ClassID in the tables and group by that. Either that or do an
append of each table to a 3rd table.

2. Unless I'm misunderstanding, can't you put the title in the Page
Header?
re***********@gmail.com wrote:
I'm teaching a few classes at a summer camp and am building a database
on the kids taking the classes and the objectives in the class. I have
two questions though.

1. I have to periods of the same class and would like to join the two
tables together, I assume with a query, to make a report. The report
is seperated by troop number (ID number for where a kid is from) and
displays all the other information from the class. I would like it to
make one report rather than a seperate report for each of the two
classes. I tried making a query and joining two tables together by the
ID Number (The auto generated value) and it only puts the kids in the
first class in the query. How should it be done?

2. I have the report grouped by the troop number with a pagebreak
after everybody that is in the same troop number. How do I add the
title and footer to each page so it shows the same title on each page
and so forth?

Thanks,

Matt


Jun 26 '06 #2
In general, you should not create two tables that store the same kind of
data. It's best to just make a field in the single table that designates
period from another, for example. To get your two tables together, you'll
need a union query, which you have to write out in SQL rather than use the
query builder. Check out union queries in help. It will look like this:
SELECT ID, firstname, lastname, "1" as period from table1 union select ID,
firstname, lastname, "2" as period from table2
hope this helps
-John

<re***********@gmail.com> wrote in message
news:11**********************@c74g2000cwc.googlegr oups.com...
I'm teaching a few classes at a summer camp and am building a database
on the kids taking the classes and the objectives in the class. I have
two questions though.

1. I have to periods of the same class and would like to join the two
tables together, I assume with a query, to make a report. The report
is seperated by troop number (ID number for where a kid is from) and
displays all the other information from the class. I would like it to
make one report rather than a seperate report for each of the two
classes. I tried making a query and joining two tables together by the
ID Number (The auto generated value) and it only puts the kids in the
first class in the query. How should it be done?

2. I have the report grouped by the troop number with a pagebreak
after everybody that is in the same troop number. How do I add the
title and footer to each page so it shows the same title on each page
and so forth?

Thanks,

Matt

Jun 27 '06 #3
Thanks guys, that all worked.

One more question. I am having trouble putting one group on each page.
A page break after the data in the detail section puts one kid on each
page. Where should a page break go to break up the groups for one
group on each page? (I set the grouping for the report to be their
troop number).

Thanks

Jun 27 '06 #4
You should have a "Sorting and Grouping" icon at the top of your Access
screen. Click that and sort by Troop Number and turn the header and
footer on. Put the Troop Number field in the Troop Number header, this
will group by Troop Number.

Repairman2003 wrote:
Thanks guys, that all worked.

One more question. I am having trouble putting one group on each page.
A page break after the data in the detail section puts one kid on each
page. Where should a page break go to break up the groups for one
group on each page? (I set the grouping for the report to be their
troop number).

Thanks


Jun 27 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: softwareengineer2006 | last post by:
All Interview Questions And Answers 10000 Interview Questions And Answers(C,C++,JAVA,DOTNET,Oracle,SAP) I have listed over 10000 interview questions asked in interview/placement test papers for...
0
by: connectrajesh | last post by:
INTERVIEWINFO.NET http://www.interviewinfo.net FREE WEB SITE AND SERVICE FOR JOB SEEKERS /FRESH GRADUATES NO ADVERTISEMENT
2
by: freepdfforjobs | last post by:
Full eBook with 4000 C#, JAVA,.NET and SQL Server Interview questions http://www.questpond.com/SampleInterviewQuestionBook.zip Download the JAVA , .NET and SQL Server interview sheet and rate...
4
by: Drew | last post by:
I posted this to the asp.db group, but it doesn't look like there is much activity on there, also I noticed that there are a bunch of posts on here pertaining to database and asp. Sorry for...
8
by: Krypto | last post by:
Hi, I have used Python for a couple of projects last year and I found it extremely useful. I could write two middle size projects in 2-3 months (part time). Right now I am a bit rusty and trying...
0
by: ramu | last post by:
C# Interview Questions and Answers8 http://allinterviewsbooks.blogspot.com/2008/07/c-interview-questions-and-answers8.html C# Interview Questions and Answers7...
1
by: ramu | last post by:
C# Interview Questions and Answers8 http://allinterviewsbooks.blogspot.com/2008/07/c-interview-questions-and-answers8.html C# Interview Questions and Answers7...
0
by: ramu | last post by:
C# Interview Questions and Answers8 http://allinterviewsbooks.blogspot.com/2008/07/c-interview-questions-and-answers8.html C# Interview Questions and Answers7...
0
by: reema | last post by:
EJB Interview Questions http://interviewdoor.com/technical/EJB-Interview-Questions.htm CSS Interview Questions http://interviewdoor.com/technical/CSS-Interview-Questions.htm C Interview Questions...
0
by: reema | last post by:
EJB Interview Questions http://interviewdoor.com/technical/EJB-Interview-Questions.htm CSS Interview Questions http://interviewdoor.com/technical/CSS-Interview-Questions.htm C Interview Questions...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.