Hello all,
I'm trying to build an query which uses several criteria. I have build the criterias:
- Depot
- Brand
- Chassis height
- Low Emission Zone
- Umwelt-sticker
- Euro
All are comboboxes and every criteria works as I want them to work. So, if I select a depot and run the query, only the trucks that drive for that depot are shown etc. When I leave all the comboboxes blank, the entire fleet is shown.
So far so good.
Now the problem.
When I select 2 criteria (e.g. Depot "Romania" and chassis height "95 / 112" ), the result of the query is that:
- All the trucks in Depot Romania are shown
and
- All the trucks in the fleet which have a chassis heigt of 95 / 112 cm are shown.
I just want to see the trucks that are in Depot Romania with a chassis height of 95 / 112 cm.
What access does is running the query and find results to either one of the querys, while I want to find results that match both criteria.
Can someone help me please?
I'm trying to build an query which uses several criteria. I have build the criterias:
- Depot
- Brand
- Chassis height
- Low Emission Zone
- Umwelt-sticker
- Euro
All are comboboxes and every criteria works as I want them to work. So, if I select a depot and run the query, only the trucks that drive for that depot are shown etc. When I leave all the comboboxes blank, the entire fleet is shown.
So far so good.
Now the problem.
When I select 2 criteria (e.g. Depot "Romania" and chassis height "95 / 112" ), the result of the query is that:
- All the trucks in Depot Romania are shown
and
- All the trucks in the fleet which have a chassis heigt of 95 / 112 cm are shown.
I just want to see the trucks that are in Depot Romania with a chassis height of 95 / 112 cm.
What access does is running the query and find results to either one of the querys, while I want to find results that match both criteria.
Can someone help me please?