㈠ 濡备綍鍦ˋCCESS涓瀹炵幇鍦ㄧ獥浣扑腑镄勬枃链妗嗕腑杈揿叆涓涓銆愪緵搴斿晢缂栧彿銆戯纴鎸変笅镆ヨ㈡寜阍锛屽湪瀛愮獥鍙ｄ腑鏄剧ず鐩稿叧鏁版嵁锛
链濂界敤缁勫悎妗嗭纴杩欐牱镞㈠彲浠ヨ窡琛ㄨ仈绯伙纴鍙埚彲浠ョ洿鎺ヨ緭鍏ユ暟鎹锛
1銆佸缓绗涓涓妗嗭纸渚涘簲鍟嗙紪鍙)锛屽彇钖嵝済ys钬濓纴鍦ㄢ滆屾潵婧愮被鍨嬧濅腑阃夆滆〃/镆ヨ⑩濓纴鍦ㄢ滆屾潵婧悫濅腑鍐欐煡璇㈣鍙ワ细SELECT distinct [浜у搧璧勬枡].[渚涘簲鍟嗙紪鍙穄 FROM [浜у搧璧勬枡]銆
2銆佸缓绗浜屼釜妗嗭纸浜у搧缂栧彿)锛屽彇钖嵝渃pbh钬濓纴鍦ㄢ滆屾潵婧愮被鍨嬧濅腑阃夆滆〃/镆ヨ⑩濓纴鍦ㄢ滆屾潵婧悫濅腑鍐欐煡璇㈣鍙ュ傦细SELECT DISTINCT 浜у搧璧勬枡.缂栧彿 FROM 浜у搧璧勬枡 WHERE (((浜у搧璧勬枡.渚涘簲鍟嗙紪鍙)=[Forms]![绐椾綋钖峕![gys]))
3銆佸缓绗涓変釜妗嗭纸浜у搧钖岖О)锛屽彇钖嵝渃pmc钬濓纴鍦ㄢ滆屾潵婧愮被鍨嬧濅腑阃夆滆〃/镆ヨ⑩濓纴鍦ㄢ滆屾潵婧悫濅腑鍐欐煡璇㈣鍙ュ傦细SELECT DISTINCT 浜у搧璧勬枡.浜у搧钖岖О FROM 浜у搧璧勬枡 WHERE (((浜у搧璧勬枡.渚涘簲鍟嗙紪鍙)=[Forms]![绐椾綋钖峕![gys]))
鍙浠ュ疄鐜颁綘镄勮佹眰锛氲緭鍏ヤ緵搴斿晢缂栧彿锛屼笅闱涓ゆ呜嚜锷ㄦ樉绀轰骇鍝佺紪鍙峰强钖岖О銆