㈠ 濡備綍鍦ˋCCESS涓瀹炵幇鍦ㄧ獥浣撲腑鐨勬枃鏈妗嗕腑杈撳叆涓涓銆愪緵搴斿晢緙栧彿銆戱紝鎸変笅鏌ヨ㈡寜閽錛屽湪瀛愮獥鍙ｄ腑鏄劇ず鐩稿叧鏁版嵁錛
鏈濂界敤緇勫悎妗嗭紝榪欐牱鏃㈠彲浠ヨ窡琛ㄨ仈緋伙紝鍙堝彲浠ョ洿鎺ヨ緭鍏ユ暟鎹錛
1銆佸緩絎涓涓妗嗭紙渚涘簲鍟嗙紪鍙)錛屽彇鍚嶁済ys鈥濓紝鍦ㄢ滆屾潵婧愮被鍨嬧濅腑閫夆滆〃/鏌ヨ⑩濓紝鍦ㄢ滆屾潵婧愨濅腑鍐欐煡璇㈣鍙ワ細SELECT distinct [浜у搧璧勬枡].[渚涘簲鍟嗙紪鍙穄 FROM [浜у搧璧勬枡]銆
2銆佸緩絎浜屼釜妗嗭紙浜у搧緙栧彿)錛屽彇鍚嶁渃pbh鈥濓紝鍦ㄢ滆屾潵婧愮被鍨嬧濅腑閫夆滆〃/鏌ヨ⑩濓紝鍦ㄢ滆屾潵婧愨濅腑鍐欐煡璇㈣鍙ュ傦細SELECT DISTINCT 浜у搧璧勬枡.緙栧彿 FROM 浜у搧璧勬枡 WHERE (((浜у搧璧勬枡.渚涘簲鍟嗙紪鍙)=[Forms]![紿椾綋鍚峕![gys]))
3銆佸緩絎涓変釜妗嗭紙浜у搧鍚嶇О)錛屽彇鍚嶁渃pmc鈥濓紝鍦ㄢ滆屾潵婧愮被鍨嬧濅腑閫夆滆〃/鏌ヨ⑩濓紝鍦ㄢ滆屾潵婧愨濅腑鍐欐煡璇㈣鍙ュ傦細SELECT DISTINCT 浜у搧璧勬枡.浜у搧鍚嶇О FROM 浜у搧璧勬枡 WHERE (((浜у搧璧勬枡.渚涘簲鍟嗙紪鍙)=[Forms]![紿椾綋鍚峕![gys]))
鍙浠ュ疄鐜頒綘鐨勮佹眰錛氳緭鍏ヤ緵搴斿晢緙栧彿錛屼笅闈涓ゆ嗚嚜鍔ㄦ樉紺轟駭鍝佺紪鍙峰強鍚嶇О銆