null instead of zeroes (1 Viewer)

S

StuartBowen

New member

Local time

Today, 11:15

Joined

Jul 12, 2017

Messages

2

• Jul 12, 2017

• #1

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

Well-known member

Local time

Today, 06:15

Joined

Apr 9, 2015

Messages

4,337

• Jul 12, 2017

• #2

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

 

S

StuartBowen

New member

Local time

Today, 11:15

Joined

Jul 12, 2017

Messages

2

• Jul 12, 2017

• #3

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.