want to filter a report

[jakobt]

Having a report based on record source of a select query with some related table.

I want to run the report for only Countries: France

How can i filter the report on countries france?

 

[alansidman]

Add a parameter to your query and when you run the report, it will ask for the parameter criteria.

 

[Trevor G]

If it is France only then add that into your query as criteria. Or are you wanting to type in a parameter as Alan is suggesting, or do you want to select a country to filter on?

 

[jakobt]

Thank you. However, I want this to be a predefined condition in my query.

Would I need to add a where clause to my query. Again the query combines 3 tables. Customers, product and Market. Primary keys customerid, productid and marketid.

Can I enter a where clause related to where marketid = "france"

 

[Trevor G]

Is Marketid a list rather than values? If yes then as you create your query use the marketid and in the criteria type in France