null instead of zeroes

[StuartBowen]

Hi

I have a client who is connecting a Mac running parallels with Windows 10 Pro and Access as part of Office 365 on latest updates. He is connecting to an SQL 2012 database via ODBC. The issue us that if the table has a zero in a field, the data is presented as a null in the linked Access table. It is only happening on this clients PC, if I connect to the data source, I get zeroes.

Any ideas greatly received.

 

[Ranman256]

There may be a setting in the ODBC to interpret nulls as zero.
Or
Use NZ(field) to convert it in the query.

 

[StuartBowen]

Thanks and currently working round using NZ but don't want to, since it only affects the one computer. The ODBC settings on that computer are the same as mine and mine displays zeros not nulls.