Yes/No field in conversion (1 Viewer)

[P_Henry]

Hi,

I am really sad that all my previous posts have gone..didn't ever think this could happen.

Anyway, I did get my Access to SQL server conversion done. All "Yes/No" fields have been converted to a byte. This has got rid of the "-" in the "-1" field which corresponds to "Yes" in Access.
My DB frontend has reports and forms which are based on queries which have "-1" as a selection criteria.
Now...I have 2 options to handle this...change the byte declaration to integer. OR change my front-end queries to have criteria as '1" instead of "-1".

Is this a common problem??

Is changing my front-end the better option??

Any help will be appreciated.

Thanks,
priya

 

[Kodo]

change the Front End queries.. I'm sure it won't take too long.

 

[FoFa]

How about changing your front end to = 0 or <> 0 instead?

 

[P_Henry]

Thanks...I will change all my front end queries.

Priya