Query produces strange result

[Rowey]

Hi all
Can any one work out what is happenning with the "GetSplitQry" query result for "Pbox 102" and "Pbox 98" in the attached database. It has me stumped.

Thans
Brice

 

[essaytee]

You're going to kick yourself for this one. The query is returning the correct result. Check your table data, at the offending lines. In the datasheet mode, widen the rows, you will see the data has been duplicated or triplicated. Very hard to notice by the default row height.

 

[Rowey]

I'm embarrassed. I knew it was something like that but was blinded by my own expectation that it was some glitch!!:banghead: Thanks essaytee.

 

[essaytee]

No problems, just needed fresh eyes.