访问查询以使列显示为是/否列的复选框 [英] Access query to make column that shows checkbox for Yes/No column

问题描述

我写了一个查询来在MS-access中创建一个表:

I've written a query to create a table in MS-access:

CREATE TABLE [customers]
([id] NUMBER, [authorised] YESNO);

这很好.但是，当我真的希望一个复选框时，是/否"列显示-1和0.

This works fine. However the YES/NO column displays -1 and 0, when I'd really rather a checkbox.

在查询中有什么方法可以做到这一点?

Is there any way to do this within the query?

推荐答案

这是一个已知的错误:

This is a known bug: ACC2002: Make-Table Query Does Not Format Yes/No or Bit Fields Correctly. The Knowledge Base article proposes two workarounds, unfortunately none of them one can use in a query.

这篇关于访问查询以使列显示为是/否列的复选框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！