<div>
thanks for the suggestions since i have posted the questions i have tried to run the query from another computer and it works perfectly<br />
<br />
do you know why this might be<br />
<br />
i thought it was impossible but i have checked all the results it brings up and they are perfect
</div>


thanks for the suggestions since i have posted the questions i have tried to run the query from another computer and it works perfectly

do you know why this might be

i thought it was impossible but i have checked all the results it brings up and they are perfect

<div>
<div class="content wysiwyg-content">
i have an app that filters what records a shown depending on what button is clicked.<br />
<br />
the problem i have is that one of the filters requires me to join the customers table to another table on the ID field and select distinct records so i only end up viewing each customer once.<br />
<br />
the problem is that the distinct query says it cannot select distinct on memo fields. &nbsp;i need to show this memo field. &nbsp;is there any way around it<br />
<br />

</div>
</div>


i have an app that filters what records a shown depending on what button is clicked.

the problem i have is that one of the filters requires me to join the customers table to another table on the ID field and select distinct records so i only end up viewing each customer once.

the problem is that the distinct query says it cannot select distinct on memo fields.  i need to show this memo field.  is there any way around it



distinct records query

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.