What I want to do:
I've been going nuts trying to make Access to update a Yes/No field.
I'm writing a Database to be used with a Handheld.
1)Records regarding the Order status will be updated in handheld and on desktop computers.
2)I have been able to update the Yes/No records that were changed on the Handheld.
3)There is a Status table on the desktop that tells if record is finished or not, it is independent from the table in the Handheld. This Status Table connects to the Orders table.
My Problem:
My problem is that I have not beeing able to update the Yes/No field on the Main Orders Table.
What I have tried:
1)I have made a Selection querry, it works fine.
2)The Update querry shows the records I want to change, but the Yes/No Field is mantained as "uncheked". It won't change no matter what value I put on the "Update to:" field on the Query.
Any suggestions or tips on how to solve this?
I've been going nuts trying to make Access to update a Yes/No field.
I'm writing a Database to be used with a Handheld.
1)Records regarding the Order status will be updated in handheld and on desktop computers.
2)I have been able to update the Yes/No records that were changed on the Handheld.
3)There is a Status table on the desktop that tells if record is finished or not, it is independent from the table in the Handheld. This Status Table connects to the Orders table.
My Problem:
My problem is that I have not beeing able to update the Yes/No field on the Main Orders Table.
What I have tried:
1)I have made a Selection querry, it works fine.
2)The Update querry shows the records I want to change, but the Yes/No Field is mantained as "uncheked". It won't change no matter what value I put on the "Update to:" field on the Query.
Any suggestions or tips on how to solve this?