Hello I have a question About DISTINCT The Records by a command button. I searched but, can't find anything like that..
I have a Continuous form based on a query and I use "SELECT DISTINCT ........ it works perfectly DISTINCTS the records as needed, but i want to add on the form a command button and being clicked must remove distinct
I thought and decided to create two query for that form and by command button or toggle button change the destination record source. Is that possible or there is another way...
Thank you in advanced
I have a Continuous form based on a query and I use "SELECT DISTINCT ........ it works perfectly DISTINCTS the records as needed, but i want to add on the form a command button and being clicked must remove distinct
I thought and decided to create two query for that form and by command button or toggle button change the destination record source. Is that possible or there is another way...
Thank you in advanced
Last edited: