Need some help on report filter

[harky]

Hi, is it possible to filter report by [English]

I had a table which show

Student ID | subject
001 | English
001 | maths
002 | science
002 | English

 

[Joe4]

Typically, it is best to based all Forms and Reports on Queries, and not on Tables directly.
If they are based on Queries, you can add any Filters and calculations that you like, and easily change them.
You can even use Parameter Queries, which will prompt the user to enter a filter value at run-time.

 

[harky]

Actually I set the filter on my Queries but when I base on the Queries to create the report. It don't generated out what base on the filter I set on my queries. I want to hard-coded it rather than let user input it.

I filter to display [English] on queries but it still display other all subject on my report.

 

[Joe4]

In Design View of your query, just place the word "English" on the Criteria line under the Subject field and save your query.

See here for more details and examples: https://support.office.com/en-us/ar...criteria-3197228c-8684-4552-ac03-aba746fb29d8

 

[harky]

Yes I did.. But when I create report. It don't filter and display English.

Is not the query is the report

 

[xenou]

First create the query that filters for English.
Then base the report on that query.

 

[Joe4]

Yes I did.. But when I create report. It don't filter and display English.

Is not the query is the report

If sounds like the Query is NOT the Record Source of your Report.
If you open your Report, and go to the Properties, see what the Record Source is set to.

As Xenou stated, the usual order of events is to create the Query first, then create the Report off of the Query, not the Table.
If you do that, the Record Source of the Query will automatically be set to your Query. And you can edit the Query after that, and those changes will be reflected on the Report.

 

[harky]

thanks all..
i think i fix the problem

Solution is
I change my Subject column to text box in design view
There was a drop down list so it wont able to display the English which suppose to..