我想使用下面的if语句在sn1列中使用修改后的序列号。如何将下面的if语句进行查询?If Len([sn]) <= 12 Then Me.sn1 = Me.sn If Len([sn]) = 13 And Left([sn], 1) = "S" And Not IsNumeric(Mid([sn], 2, 3)) Then Me.sn1 = Right([sn<
在第一个查询中,我有一个包含序列号和标题的表:select wrote.serial_number as SN, count(wrote.serial_number) as NumOfPapersgroup by wrote.serial_number;
我得到了一个带有SN和每个SN的标题计数的视图,而我希望获得标题最多的行(max ofcount),如下所示: ID