Filter
- Thread starter EJohns
- Start date
tvanstiphout
Active member
- Local time
- Today, 04:03
- Joined
- Jan 22, 2016
- Messages
- 318
Is this school work?
- Local time
- Today, 06:03
- Joined
- Feb 19, 2002
- Messages
- 45,438
Create a query that joinsStudents, StreamStudents, TermStudents, YearTerms, GradeStream and add criteria for year, grade, and stream
This can't be a coincidence:
Is this homework? Do you work with victorlindh? Are you victorlindh?
The fields/tables in the database in the thread I have linked above is 95% the same as the one you posted--including the names. Why is that?
Hide inactive data and show active data only.
Hi everyone. I am making school database. I am defeated on how to show only active data. For example we have 3 terms in a year. I want to hide data for previous years for example in 2025 term 3 to be shown and hide for previous years and terms. I wish when the form(FORM4) is opened, the user...
www.access-programmers.co.uk
Is this homework? Do you work with victorlindh? Are you victorlindh?
The fields/tables in the database in the thread I have linked above is 95% the same as the one you posted--including the names. Why is that?
I really need help. Thanks @Pat Hartman
- Local time
- Today, 06:03
- Joined
- Feb 19, 2002
- Messages
- 45,438
Did you try to make the query?
To be honest I don't know how to do it. I am defeated. I am still new in ms access.
Gasman
Enthusiastic Amateur
- Local time
- Today, 11:03
- Joined
- Sep 21, 2011
- Messages
- 15,707
- Local time
- Today, 11:03
- Joined
- Feb 19, 2013
- Messages
- 17,094
They both share the same IP with @I am alive
- Local time
- Today, 06:03
- Joined
- Feb 19, 2002
- Messages
- 45,438
That video is way too complex for someone who has no concept of queries. I'm sure there are many that are simpler but here are some basic directions.
@EJohns When you are new to SQL, the easiest way to build a query is to use the QBE (Query By Example) tool.
Click on The Create tab
Then QueryDesign
The default query type will be Select. Choose each table and add it to the grid.
If you have defined relationships using the Relationship window, Access will automatically draw the join lines to connect each table. Otherwise, you will need to draw the join lines.
Here is a picture of a query from my tax database because that is what I am doing today. It only has three tables but it should be simple enough for you to follow and it is the same kind of query you need
To draw the join lines, click on the column in the left table. Hold and draw a line to the matching field on the table to the right. If the names match, Access will fill them in. If they don't, you will need to fill them in using the dialog. Draw lines to each related table. The last two tables will not join to each other but will both join to the table to the left of the next to last table.
Press the big sigma button to create the totals query. Access adds "Group By" to the "Total" line for each column. Chang them as necessary. As you can see, I have Sum, Count, and Where as well as two group by's.
@EJohns When you are new to SQL, the easiest way to build a query is to use the QBE (Query By Example) tool.
Click on The Create tab
Then QueryDesign
The default query type will be Select. Choose each table and add it to the grid.
If you have defined relationships using the Relationship window, Access will automatically draw the join lines to connect each table. Otherwise, you will need to draw the join lines.
Here is a picture of a query from my tax database because that is what I am doing today. It only has three tables but it should be simple enough for you to follow and it is the same kind of query you need
To draw the join lines, click on the column in the left table. Hold and draw a line to the matching field on the table to the right. If the names match, Access will fill them in. If they don't, you will need to fill them in using the dialog. Draw lines to each related table. The last two tables will not join to each other but will both join to the table to the left of the next to last table.
Press the big sigma button to create the totals query. Access adds "Group By" to the "Total" line for each column. Chang them as necessary. As you can see, I have Sum, Count, and Where as well as two group by's.
Last edited:
Thanks so much mum. You have been of great help in understanding the concept of ms access. You are a great teacher. May God bless you so much mum.
Last edited:
Gasman
Enthusiastic Amateur
- Local time
- Today, 11:03
- Joined
- Sep 21, 2011
- Messages
- 15,707
Pat is currently still a lady.
No wonder she answers perfectly. God will bless her so much. She is not critical. She is a good teacher. Thanks @Pat HartmanPat is currently still a lady.
- Local time
- Today, 06:03
- Joined
- Feb 19, 2002
- Messages
- 45,438
You are most kind. You're very welcome
- Local time
- Today, 06:03
- Joined
- Feb 19, 2002
- Messages
- 45,438
But you've only just started. You need to watch a few very basic videos. Crystal (@strive4peace ) has some good beginner videos on her youtube channel.
LearnAccessByCrystal
Access! Love it so much! Here you will find video tutorials to help you understand more about this amazing tool for organizing and managing information. Video descriptions have information and links that might be interesting to you, and sometimes timecodes for quickly jumping to spots. Use...
www.youtube.com
Look at the Learning Access section.
strive4peace
AWF VIP
- Local time
- Today, 05:03
- Joined
- Apr 3, 2020
- Messages
- 1,024
Learn Access playlist on YouTube
www.youtube.com
Learn Access By Crystal
Learn how to get started building an Access database application. First is planning -- do not neglect this important step. http://www.youtube.com/playlist?p=...
www.youtube.com
