Ha Ha! I'm ahead of you Boris. I've sent you an email.
This is a slightly different table (hence the SQL similar but not the same). With the other table, ETMDATA, we just needed to catch the DATE of each record, being within the date range. This is non-ETM (i.e. not from an Electronic Ticket Machine), NOTETEM and each rec states how many passengers there were between 2 dates (as opposed to ETM where it was how many passnegers ON a date)
Your servant, sir
Terry
>Did you use those table you sent once to me? If yes can you post the operator code and both periods to play with?
>
>>Hello again BB
>>
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.