select distinct(field) from table

ric123
ric123 Member Posts: 8
edited 2011-05-19 in NAV/Navision Classic Client
select distinct(field) from table

how can i do something like this in navision?

Comments

  • miguel.tiago
    miguel.tiago Member Posts: 6
    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
    samemery Member Posts: 60
    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

Categories