Prev: Sort continous form by 2 colums
Next: email help
From: James Hall on 4 Apr 2010 00:40
jhall(a)myglnc.com
"LindaSD" <LindaSD(a)discussions.microsoft.com> wrote in message
news:2EE7B0EB-BA52-468D-8519-41870C46B145(a)microsoft.com...
>I want to add a yes/no field but don't want my old data to have a value in
> this field only newly entered data to have the user make the selection.
> When
> I add the yes/no type field, even with no default value, it adds no to all
> the old data. The default comes up 0 and then it also fills in all the
> old
> data with 0. This makes reporting a mess since "no" is not necessarily
> correct on the old data and I will not be going back in the old data to
> find
> the correct answer. I want the old data to just stay blank for this
> field.
>
> Do I have to just make a text field with a lookup for yes/no so that it
> leaves the old data blank and going forward have the user complete the
> field?

From: David Jennings on 12 Apr 2010 10:59
REMOVE
"James Hall" <Jhall(a)microsoft.com> wrote in message
news:D9DBEA3F-ED03-453C-98A3-E17472115774(a)microsoft.com...
> jhall(a)myglnc.com
> "LindaSD" <LindaSD(a)discussions.microsoft.com> wrote in message
> news:2EE7B0EB-BA52-468D-8519-41870C46B145(a)microsoft.com...
>>I want to add a yes/no field but don't want my old data to have a value in
>> this field only newly entered data to have the user make the selection.
>> When
>> I add the yes/no type field, even with no default value, it adds no to
>> all
>> the old data. The default comes up 0 and then it also fills in all the
>> old
>> data with 0. This makes reporting a mess since "no" is not necessarily
>> correct on the old data and I will not be going back in the old data to
>> find
>> the correct answer. I want the old data to just stay blank for this
>> field.
>>
>> Do I have to just make a text field with a lookup for yes/no so that it
>> leaves the old data blank and going forward have the user complete the
>> field?
>

From: Larry Linson on 12 Apr 2010 18:03
What are you trying to accomplish by posting the word "REMOVE" to this
newsgroup? In this context, it does nothing at all. Perhaps there is another
way to accomplish what you want.

Larry Linson
Microsoft Office Access MVP

"David Jennings" <davidajennings(a)verizon.net> wrote in message
news:uI1zQDl2KHA.1016(a)TK2MSFTNGP02.phx.gbl...
> REMOVE
> "James Hall" <Jhall(a)microsoft.com> wrote in message
> news:D9DBEA3F-ED03-453C-98A3-E17472115774(a)microsoft.com...
>> jhall(a)myglnc.com
>> "LindaSD" <LindaSD(a)discussions.microsoft.com> wrote in message
>> news:2EE7B0EB-BA52-468D-8519-41870C46B145(a)microsoft.com...
>>>I want to add a yes/no field but don't want my old data to have a value
>>>in
>>> this field only newly entered data to have the user make the selection.
>>> When
>>> I add the yes/no type field, even with no default value, it adds no to
>>> all
>>> the old data. The default comes up 0 and then it also fills in all the
>>> old
>>> data with 0. This makes reporting a mess since "no" is not necessarily
>>> correct on the old data and I will not be going back in the old data to
>>> find
>>> the correct answer. I want the old data to just stay blank for this
>>> field.
>>>
>>> Do I have to just make a text field with a lookup for yes/no so that it
>>> leaves the old data blank and going forward have the user complete the
>>> field?
>>
>



 | 
Pages: 1
Prev: Sort continous form by 2 colums
Next: email help