silentwolf
Well-known Member
- Joined
- May 14, 2008
- Messages
- 1,216
- Office Version
- 2016
Hi again everybody!
I have been working on a database in access 07 where I created tables forms and so on.
Now I am getting to wards queries and there is one problem I can not seam to work out.
I have tblKontakts where I have a yes/no field... when I select yes it means that contact is a customer rather then a contact.
When I like to run a query saying in kriteria of tblContacts (fieldKunde) yes I want that only customers are showing.
I have created the query with typing Ja (Yes) in that field.
The problem:
When I run the quiery there are dublikates shown.
I am not sure why that could be?
Maybe someone can give me a hint please so I can make that work
Many thanks
SW
I have been working on a database in access 07 where I created tables forms and so on.
Now I am getting to wards queries and there is one problem I can not seam to work out.
I have tblKontakts where I have a yes/no field... when I select yes it means that contact is a customer rather then a contact.
When I like to run a query saying in kriteria of tblContacts (fieldKunde) yes I want that only customers are showing.
I have created the query with typing Ja (Yes) in that field.
The problem:
When I run the quiery there are dublikates shown.
I am not sure why that could be?
Maybe someone can give me a hint please so I can make that work
Many thanks
SW