select distinct(field) from table

ric123

select distinct(field) from table

how can i do something like this in navision?

miguel.tiago

Select distinct it's not possible in c/side
There's a workaround that you can make using flowfields, but i'l need more information in what you want to to evaluate if it's possible.

samemery

Hi,

I want to be able to count the distinct records in the example:

Table data:

Sale # Customer #
TS00001 C0000001
TS00001 C0000001
TS00001 C0000002
TS00001 C0000003
TS00001 C0000003


I need a flowfield set up to tell me how many distinct occuances of customer number there are for the sale number X (in this case TS00001). So the flowfield in this occasion should return 3

Is this possible?

Thanks