[AccessD] db execute on linked vs local table

[Arthur Fuller]

All this is way beyond my senior years. so I am going to stop using Yes/No
fields and instead use something I know how to deal.

On Tue, Feb 1, 2022 at 10:42 AM Bill Benson <bensonforums at gmail.com> wrote:

> I hope this is not hijacking the thread. At least that is not my intention.
> Since this is a thread regarding how Access interprets true and false, I
> thought I would point out what I feel is a bit of an anomaly.
>
> My table aaTF has been designed with two fields, one is Yes/No, the other
> is number. I entered the following data:
> *Record     TF1      TF2*
> 1          Yes      1
> 2          No       0
> 3          Yes     -1
> 4          Yes      10
>
> For a form in design view, I used this recordsource SELECT
> iif(TF1,TRUE,FALSE) AS TF1_String, iif(TF2,TRUE,FALSE) AS TF2_String FROM
> aaTF
>
> From my point of view, the value returned to the TF1_String and TF2_String
> fields should be 100% driven by whether the IIF() will return either True
> or False.
>
> Yet instead, this is the result
> *Record     TxtF1  TxtTF2*
> 1          Yes      1
> 2          No       0
> 3          Yes     -1
> 4          Yes     -1
>
> To me this makes zero sense, why should the fact that the TF1 field was
> Yes/No have anything to say about the format of the display, which I had
> asked to be a string?
>
> On Tue, Feb 1, 2022 at 10:05 AM Ryan W <wrwehler at gmail.com> wrote:
>
> > Well I was talking strictly for Access Checkboxes and SQL server bit
> > fields.
> >
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Arthur