Query produces strange result (1 Viewer)

R

Rowey

Registered User.

Local time

Today, 21:56

Joined

Oct 18, 2018

Messages

20

• Feb 18, 2019

• #1

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

 

Attachments

• Warehouse.accdb

  2 MB · Views: 50

essaytee

Need a good one-liner.

Local time

Today, 23:56

Joined

Oct 20, 2008

Messages

512

• Feb 18, 2019

• #2

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.

 

R

Rowey

Registered User.

Local time

Today, 21:56

Joined

Oct 18, 2018

Messages

20

• Feb 18, 2019

• #3

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

Need a good one-liner.

Local time

Today, 23:56

Joined

Oct 20, 2008

Messages

512

• Feb 18, 2019

• #4

No problems, just needed fresh eyes.