access按中文字段的拼音首字母查询如只查询，中文字段拼音首字母为H的所有的中文字段。

我以前有做过用MSSQL查询的，这是代码，你可以测试一下，我手头上没有ACCESS select isnull(b.py,upper(left(a.username,1))) as py ,a.username from ( select 'a3' as username union select UserName from UserTable --修改这里的姓名列~ ) a left outer join ( select 'A' as PY,N'驁' as word, N'啊' as sword union select 'B',N'簿',N'驁' union select 'C',N'錯',N'簿' union select 'D',N'鵽',N'錯' union select 'E',N'樲',N'鵽' union select 'F',N'鰒',N'樲' union select 'G',N'腂',N'鰒' union select 'H',N'夻',N'腂' union select 'J',N'攈',N'夻' union select 'K',N'穒',N'攈' union select 'L',N'鱳',N'穒' union select 'M',N'旀',N'鱳' union select 'N',N'桛',N'旀' union select 'O',N'漚',N'桛' union select 'P',N'曝',N'漚' union select 'Q',N'囕',N'曝' union select 'R',N'鶸',N'囕' union select 'S',N'蜶',N'鶸' union select 'T',N'籜',N'蜶' union select 'W',N'鶩',N'籜' union select 'X',N'鑂',N'鶩' union select 'Y',N'韻',N'鑂' union select 'Z',N'咗',N'韻' ) b on left(username,1) between b.sword and b.word where UserName<>'a3' and py='A' --这里的and py='A'是查询以A拼音开头的姓名，你可以 改成其他的，或者直接去掉就是查询所有的~ order by py

希望采纳

温馨提示：答案为网友推荐，仅供参考

当前网址：https://verywind.cn/ee/322x7y2xfvjvr33fye.html