Re: True/False : 1/0
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
=IF(YourOriginalFormula,1,0)
--
Kind regards,
Niek Otten
"will" <will@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:61F19C32-3878-40F6-BA46-53E549E38BD2@xxxxxxxxxxxxxxxx
> Hi,
>
> I'm sure this is a simple query, but can you convert true/false returns
> into
> 1/0? I have a page full of either "true or false"'s, and it is much easier
> to
> see where you are if you are just dealing with 1 or 0's.
>
> Thanks,
>
> Will
.
Relevant Pages
- "Did use to be" or "did used to be"?
... If you want to query someone whether it commonly was as cold as it is ... Kind regards, ... Prev by Date: ...
(alt.usage.english) - Re: Changing 0 to 1 in a table
... a true/false or yes/no field, you need to do a little more research before ... Rick B ... > have it in a query. ... Prev by Date: ...
(microsoft.public.access.queries) - RE: Seting format to be 000000000000000
... "Beth" wrote: ... > Ideally I want to do this in a query without any manual steps as it will be ... > Kind Regards, ... Prev by Date: ...
(microsoft.public.access.queries) - RE: Seting format to be 000000000000000
... Further to my last post, because you have this in the query section, add ... "Beth" wrote: ... > Kind Regards, ... Prev by Date: ...
(microsoft.public.access.queries) - Last day
... query which returns only the value of the last day per month. ... Kind regards, ... Simon ... Prev by Date: ...
(microsoft.public.access.queries) |
|
