如何编写Access/Excel查询，批量修改指定列对应字段值为TRUE

Access 解决方案 #

更新查询实现 #

直接使用Access的更新查询匹配指定ID列表并修改目标字段：

1. 打开Access，选中目标表，进入查询设计视图
2. 在查询类型中选择更新查询
3. 将nParentSectionID字段拖入设计网格，在其条件行输入IN (你的ID列表)
4. 将bSuppressHtml字段拖入设计网格，在其更新到行输入True（布尔字段）或"TRUE"（文本字段）
5. 运行查询，确认修改记录数后完成

对应的SQL语句（替换你的表名为实际表名）：

UPDATE 你的表名
SET bSuppressHtml = True
WHERE nParentSectionID IN (1, 10, 20, 22, 23, 37, 68, 97, 101, 103, 106, 115, 116, 118, 119, 120, 121, 122, 123, 124, 127, 129, 130, 131, 133, 136, 137, 141, 148, 157, 159, 160, 165, 166, 169, 170, 172, 174, 175, 176, 178, 180, 182, 184, 186, 187, 188, 190, 191, 193, 198, 200, 201, 202, 226, 229, 230, 231, 238, 241, 244, 247, 249, 252, 256, 259, 262, 263, 264, 266, 268, 270, 271, 277, 278, 280, 281, 282, 284, 286, 292, 296, 299, 307, 310, 319, 325, 329, 331, 335, 340, 341, 346, 348, 353, 362, 365, 366, 370, 374, 382, 383, 385, 386, 410, 412, 413, 416, 418, 419, 428, 429, 444, 446, 448, 451, 453, 456, 462, 463, 467, 469, 493, 500, 501, 502, 503, 505, 506, 511, 512, 515, 519, 525, 526, 527, 532, 535, 536, 537, 550, 551, 555, 563, 565, 566, 567, 573, 575, 576, 577, 578, 579, 581, 595, 598, 599, 603, 609, 611, 623, 626, 627, 640, 641, 642, 643, 644, 647, 651, 654, 655, 664, 669, 670, 672, 688, 689, 690, 695, 696, 697, 702, 705, 706, 716, 717, 725, 729, 731, 732, 738, 740, 741, 743, 744, 746, 749, 751, 752, 753, 757, 758, 759, 768, 772, 779, 782, 783, 802, 805, 810, 811, 814, 818, 819, 821, 836, 841, 846, 847, 849, 852, 854, 857, 862, 871, 872, 877, 882, 920, 922, 923, 930, 934, 935, 937, 938, 942, 944, 952, 958, 963, 981, 984, 987, 988, 991, 994, 1037, 1041, 1051, 1058, 1059, 1060, 1062, 1064, 1067, 1071, 1075, 1095, 1117, 1119, 1133, 1140, 1164, 1166, 1182, 1203, 1211, 1226, 1234, 1240, 1241, 1242, 1244, 1251, 1252, 1253, 1272, 1281, 1283, 1310, 1321, 1322, 1335, 1342, 1346, 1348, 1350, 1353, 1355, 1365, 1373, 1384, 1390, 1392, 1394, 1405, 1413, 1414, 1415, 1417, 1424, 1425, 1430, 1464, 1465, 1468, 1471, 1476, 1482, 1484, 1528, 1532, 1534, 1540, 1560, 1565, 1568, 1569, 1571, 1573, 1576, 1577, 1602, 1603, 1605, 1685, 1714, 1756, 1764, 1776, 1782, 1783, 1786, 1834, 1865, 1974, 1980, 1981, 1983, 1994, 1997, 2023, 2078, 2081, 2087, 2099, 2104, 2116, 2119, 2121, 2125, 2127, 2130, 2135, 2139, 2142, 2146, 2155, 2156, 2191, 2207, 2220, 2227, 2236, 2288, 2329, 2330, 2337, 2363, 2366, 2368, 2371, 2379, 2395, 2422, 2440, 2510, 2550, 2596, 2664, 2716, 2727, 2733, 2772, 2782, 2832, 2874, 2889, 2895, 2945, 2951, 3010, 3050, 3148, 3168, 3169, 3170, 3187, 3254, 3261, 3264, 3278, 3282, 3286, 3292, 3408, 3417, 3427, 3428, 3433, 3479, 3487, 3576, 3588, 3592, 3598, 3600, 3605, 3640, 3656, 3660, 3668, 3669, 3673, 3682, 3691);

Excel 解决方案 #

方法1：公式批量处理 #

假设nParentSectionID在A列，bSuppressHtml在B列，在B2单元格输入以下公式，下拉填充至所有行：

=IF(ISNUMBER(MATCH(A2, {1,10,20,22,23,37,68,97,101,103,106,115,116,118,119,120,121,122,123,124,127,129,130,131,133,136,137,141,148,157,159,160,165,166,169,170,172,174,175,176,178,180,182,184,186,187,188,190,191,193,198,200,201,202,226,229,230,231,238,241,244,247,249,252,256,259,262,263,264,266,268,270,271,277,278,280,281,282,284,286,292,296,299,307,310,319,325,329,331,335,340,341,346,348,353,362,365,366,370,374,382,383,385,386,410,412,413,416,418,419,428,429,444,446,448,451,453,456,462,463,467,469,493,500,501,502,503,505,506,511,512,515,519,525,526,527,532,535,536,537,550,551,555,563,565,566,567,573,575,576,577,578,579,581,595,598,599,603,609,611,623,626,627,640,641,642,643,644,647,651,654,655,664,669,670,672,688,689,690,695,696,697,702,705,706,716,717,725,729,731,732,738,740,741,743,744,746,749,751,752,753,757,758,759,768,772,779,782,783,802,805,810,811,814,818,819,821,836,841,846,847,849,852,854,857,862,871,872,877,882,920,922,923,930,934,935,937,938,942,944,952,958,963,981,984,987,988,991,994,1037,1041,1051,1058,1059,1060,1062,1064,1067,1071,1075,1095,1117,1119,1133,1140,1164,1166,1182,1203,1211,1226,1234,1240,1241,1242,1244,1251,1252,1253,1272,1281,1283,1310,1321,1322,1335,1342,1346,1348,1350,1353,1355,1365,1373,1384,1390,1392,1394,1405,1413,1414,1415,1417,1424,1425,1430,1464,1465,1468,1471,1476,1482,1484,1528,1532,1534,1540,1560,1565,1568,1569,1571,1573,1576,1577,1602,1603,1605,1685,1714,1756,1764,1776,1782,1783,1786,1834,1865,1974,1980,1981,1983,1994,1997,2023,2078,2081,2087,2099,2104,2116,2119,2121,2125,2127,213