Query has multiple rows in one record

[dartagnan1098]

Please see the attached image for what is happening.

 

[boblarson]

That formatting doesn't look like Access 2002. It looks like 2007 or 2010. Access 2002 doesn't have those arrows on the columns of the query.

 

[boblarson]

What type of file do you have - mdb, mde, accdb, or accde?

 

[dartagnan1098]

Sorry I did open the mdb in 2010 to see if I the same thing would happen. I took the snapshot while I was in 2010. Same thing happens in 2002 on XP and 2010 on Win 7.

 

[boblarson]

1. Can you scramble the data and upload a copy of the 2002 file here. I want to look inside of it. It would have to be an mdb file if it is 2002 and that wouldn't have multivalue fields and then I'd be trying to find out how it is doing that because it does not look right for a 2002 database file. It still looks like a 2007/2010 multivalue field which doesn't exist in a 2002 file.

2. The reason I want to see the actual database file is twofold.

• I want to see if the file is what I think it is.
• I want to see the actual tables and query (including in design view)

 

[The_Doc_Man]

It looks like only one field is actually messed up. The other fields are just innocent victims of the problem of dynamic row resizing.

This can happen when the field containing the anomalous data includes embedded ASCII (or UNICODE) carriage control characters. If that is what is happening, it is an artifact of the way you brought this in.

It could also happen (I think) if the one column with anomalous behavior is an embedded object of some kind.

If that isn't a table or query but rather is a continuous form, you can have that same effect with the items in the anomalous column being complex BLOB items.

However, I still think you should let Bob look at it in detail.