G
Guest
Hi,
I have a query which shows "Work in Progress" on my database. this query is
displayed on a form in a unbound list.
The problem im having is that users arent signing off complete work (very
annoying). so what iv done is added an extra column which shows if the work
has been completed by the previous process (if yes then it should be complete
for the one they are signing off).
However the new column is only displaying 0 and -1 rather than yes/no. i
have tried changing the properties in the query to yes/no but it just reverts
back after i save and close the query.
Any ideas on how to force it to show yes/no
I have a query which shows "Work in Progress" on my database. this query is
displayed on a form in a unbound list.
The problem im having is that users arent signing off complete work (very
annoying). so what iv done is added an extra column which shows if the work
has been completed by the previous process (if yes then it should be complete
for the one they are signing off).
However the new column is only displaying 0 and -1 rather than yes/no. i
have tried changing the properties in the query to yes/no but it just reverts
back after i save and close the query.
Any ideas on how to force it to show yes/no