Select count(distinct fieldA) in access
Just now, i need to compare my source (MS SQL Server) and my target table (access db).
For mssql, i use this query:
select count(distinct cust_code) from ODSCustomer
and when i run this query on access,it give me error. as usual, when it comes to this situation,google search always save my time a lot. 
here is the solution for this problem.
Just change my query to this.
select count(*) from (select distinct cust_code from ODSCustomer)
As a programmer, i believe you guys also will face this kind of situation.Just use google,will save your time a lot.
If you're new here, you may want to subscribe to my RSS feed or get my latest post directly in your mailbox. Thanks for visiting !
cara cam ni banyak digunakan kat sub select dan join query tak pon tahap dewa super panjang sql query yang selalu aku jumpa eheh
ehehe..tahap dewa nye super panjang eh gerg.
yang penting kena tahu basic utk sql tuh kan.
ya betull ..kekadang pengentahuan sql nih lagi penting dr php ke apa ke ..senang idop di kemudian hari
haáh..ya betul gerg…sebab sql nie semua language pakai.. so nak tak nak..mmg kena tau sql lar kan.
dulu aku ingat tau sesikit dah laa kot sql nih sekali kena tau banyak laa plak .. hehe terpaksa nak idop
takpe gerg tau banyak tak rugi .