please solve the query

[esanray]

DATABASE CONTAIN the following type of data

Arrive STATION      Depart STATION
BBS      Cal
BBS      CAL
CAL        BBS
CAL       BBS
MAD       BOM
MAD      BOM
BOM      MAD

I WANT TO SHOW THE REPORT

ROUT      NO OF TRAIN
BBS-CAL-BBS   4
MAD-BOM-MAD   3

CAN YOU PLEASE EXPLAIN THE STEPS  IN fm or report studio

[vetteheadracer]

You need two tables Outward Journeys and Return Journeys then join From station of the Return to the To station of the Outward table.

[esanray]

i dont get your point can you please elaborate it.

[vetteheadracer]

Okay,

Given your example in your first post, you need to have two tables both containing the same data. Then create a join from the first table (OUTWARD JOURNEYS) to the second table (RETURN JOURNEYS) and the join needs to be from the TO station on the OUTWARD JOURNEYS table to the FROM station on the RETURN JOURNEYS station.