access在查询语句上如何对一个表进行按两个字段进行排序?

[ys497]

表:
bh zx xm gz
2 199703 aaa 345
2 199505 aaa 134
2 199901 aaa 455
4 199703 ddd 445
4 199505 ddd 334
4 199901 ddd 655
3 199703 aaa 234
3 199505 aaa 445
3 199901 aaa 555
......
查询结果:
bh zx xm gz
2 199503 aaa 134
2 199705 aaa 345
2 199901 aaa 455
3 199503 ddd 234
3 199705 ddd 445
3 199901 ddd 555
4 199503 aaa 334
4 199705 aaa 445
4 199901 aaa 655
......
我试用
select * from 表 order by bh and zx
select * from 表 order by bh or zx
但都不行,请高手指教!!!

[huang59]

SELECT * FROM shizhe ORDER BY bh, zx;

[huang59]

select * from 表 order by bh , zx