Strange Query behaviour - text as symbols?! (1 Viewer)

[mcclunyboy]

Hi,

I have a table (tbl_invoices) with a field delivery_description of type memo. I have another field on this table invoice_type_id which is a number acting as a foreign key to another table (tbl_invoice_type).

When I run a query against tbl_invoices everything is fine, I can see the delivery_description as the text that it is, it displays things like ("Netherlands", or "Leave at 12 if nobody in at 13" etc). However as soon as I join my table tbl_invoices (via the GUI or SQL) to tbl_invoice_type on invoice_type_id the text is no longer displayed and instead various special characters are (looks like chinese characters mixed with ascii my computer doesn't recognise....no idea).

Any one had this before, it has only recently started occuring as I use the report every month and until this month it was working fine (no changes made to access that I can see so I assume it is environment based)?

Edit - > Table displays the data correctly

Edit -> Here are some the characters: ⤒, 䈁. 㤁 ,  , 〚, 〆etc etc

All other reports/queries work fine (so far).

 

[vbaInet]

Are you grouping by any chance?

 

[vbaInet]

Just found the article on this:

http://allenbrowne.com/bug-18.html

 

[mcclunyboy]

Yeah that was it, I was grouping on the memo!

I changed it to a field of type text and it worked.

Thanks

 

[vbaInet]

No problemo!