value changes from 1 to -1 when imported from SQL server

[goldfrapp01]

Hi everybody,

I have a vba code that builds a SQL String, opens a connection to SQL server and imports the contents of a SQL View into an Access table.

Everything works fine, except one column "primary_account" where I store 1 and 0 for True and False. In Access 1 shows up as -1. Does anyone know the cause of this and how can I fix it? Thanks!

[JoeM]

I have seen different programs/languages treat Boolean's differently, using 1 and 0 or -1 and 0. Usually and easy way to handle either case is to just used the following criteria for calculations or criteria:

True: <> 0
False: =0

or you could just use True and False.

If this does not solve your issue, please explain exactly what it is that needs fixing (a calculation? query? report?).

[ssanfu]

Even within Microsoft, there are different values for TRUE between Access and Excel.

Excel : False = 0, True = 1

Access : False = 0, True = -1


So you can say: FALSE = 0 and TRUE = any number except 0 (positive or negative)

I tend to use False and Not False in code.