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
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