Filter (1 Viewer)

[EJohns]

Hi everyone. I am trying to filter to find the students in a certain year and term for grade and stream. Kindly assist me. Check attached database frmsearch. Thanks in advance.

 

[tvanstiphout]

Is this school work?

 

[Pat Hartman]

Create a query that joinsStudents, StreamStudents, TermStudents, YearTerms, GradeStream and add criteria for year, grade, and stream

 

[plog]

This can't be a coincidence:

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?

 

[EJohns]

I really need help. Thanks @Pat Hartman

 

[Pat Hartman]

Did you try to make the query?

 

[EJohns]

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]

To be honest I don't know how to do it. I am defeated. I am still new in ms access.

https://www.youtube.com/results?search_query=group+by+query

 

[CJ_London]

Is this homework? Do you work with victorlindh? Are you victorlindh?

They both share the same IP with @I am alive

 

[Pat Hartman]

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]

That video is way to 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
View attachment 113687


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.

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.

 

[Gasman]

Thanks so much sir. You have been of great help in understanding the concept of ms access. You are a great teacher. May God bless you so much sir.

Pat is currently still a lady.

 

[EJohns]

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 Hartman

 

[Pat Hartman]

You are most kind. You're very welcome

 

[EJohns]

To be honest I am defeated.

 

[Pat Hartman]

To be honest I am defeated.

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.

https://www.youtube.com/user/LearnAccessByCrystal

Look at the Learning Access section.

 

[strive4peace]

Learn Access playlist on YouTube

https://www.youtube.com/playlist?list=PL1B2705CCB40CA4CA