mawarmerah 0 Report post Posted June 22, 2005 Mintak tolonglah sesangat pada pakar2 ms access nie. Bagaimana iyea... nak buat bilangan nombor dalam report. Kiranya, bilangan nie automatik lah mengikut data yg kita ada dalam table. Masalahnya aku skrg.. taknak buat auto number di dalam table coz taknaklah nombor2 berterabur bila aku sort pada field tertentu. Maka, bila dah preview tuh... mestilah tak cantik susunan tuh.. Tolong iyea.... TQ Quote Share this post Link to post Share on other sites
Rads78 0 Report post Posted June 22, 2005 buat count utk papar jumlah rekod dalam table Select count(*) from tablename have fun Quote Share this post Link to post Share on other sites
mawarmerah 0 Report post Posted June 23, 2005 buat count utk papar jumlah rekod dalam table Select count(*) from tablename have fun←TQVM Rads78 coz sudi memberi respon... anyway, saya bukan nak jumlah rekod dlm table, tapi.. saya nak paparkan bilangan berturutan data yang ada dalam table. Setahu saya, untuk mendapatkan jumlah.. just taip =[count] didlm text box, so... apakah pula format untuk mendapatkan nombor bersiri nie......tq Quote Share this post Link to post Share on other sites
mawarmerah 0 Report post Posted June 25, 2005 erm....... takde sesapa ker yang leh jawab soklan nie!.. Quote Share this post Link to post Share on other sites
isfann 0 Report post Posted June 25, 2005 aku tak reti access Quote Share this post Link to post Share on other sites
step 0 Report post Posted June 27, 2005 Kalau SQL boleh write function.. Acess ni nak kena tengok kat Form kot.. Boleh tanya number ni nak display kat mana? HTML/Web Form ? Atau kat Access form? Quote Share this post Link to post Share on other sites
mawarmerah 0 Report post Posted June 28, 2005 Kalau SQL boleh write function.. Acess ni nak kena tengok kat Form kot.. Boleh tanya number ni nak display kat mana? HTML/Web Form ? Atau kat Access form?←Oh!.. terima kasih step coz sudi bg respon. Erm, utk pengetahuan anda.. nombor nie nak display dalam report (ms access). Pening dah saya.. pelbagai cara sudah saya buat, tp gagal. Jika saya taip =num di daLam text box tuh... yg akan keluar semuanya nombor satu. Jika saya ada 5 data, maka bilangan nombor yg keluar adalah satu. Masalahnya, saya berkehendakkan nombor tu menjadi secara automatik iaitu nombor 1 - 5. Adus... tensen tol!.. tolong ler..sesapa yg pakar. tq Quote Share this post Link to post Share on other sites
step 0 Report post Posted June 28, 2005 Hmmm.. dah lama tak buat access report ni. Kalau programing ok la.. bab bab report ni selalu nak kena check Report Menu Report form tu. Since data from Access ni yang tricky. Adre sesapa jumpa any method nak auto number recordset from the query.. I know SQL server boleh bikin tapi access ni nak kena check la.. Kalau saya jumpa ape ape saya bagitahu.Anyway.. adre tak field utk report name index?Step Quote Share this post Link to post Share on other sites
step 0 Report post Posted June 28, 2005 =num or =num + 1 Quote Share this post Link to post Share on other sites
mawarmerah 0 Report post Posted June 29, 2005 =num or =num + 1←tak jadilah step... me dah cuba.. dia akan popup Enter parameter value n then suruh masukkan nombor. bila me masukkan nombor 1.... dia akan keluar nombor 2 pada setiap data yang ada... wakakaka... erm... mmg tensen tol.Erm,... takleh jawab, takpalah... apapun.. tq bbyk coz sudi berkongsi ilmu. Quote Share this post Link to post Share on other sites
mawarmerah 0 Report post Posted June 29, 2005 Anyway.. adre tak field utk report name index?Step←erm... rasanya xde kot Quote Share this post Link to post Share on other sites
step 0 Report post Posted June 29, 2005 Cuba add field.. jangan binding to the recordset and check if AUTONUMBERING as one of the property available tak.. Rasa nyer cam pernah buat tapi 7 tahun lepas la tak tahu la new version of acess still ader lagi. Sebab mende ynag you nak ni memang common and I am sure mesti ader cara. Quote Share this post Link to post Share on other sites
mawarmerah 0 Report post Posted June 30, 2005 YESS!!!.... me dah tau solutionnya.. keh keh keh.....erm, rupanya just taip =1 dalam textbox, and then p kat properties > running sum, amik Over group or over sum.hehehe.... anyway, thanx to step di atas usaha anda berkongsi ilmu. Quote Share this post Link to post Share on other sites
step 0 Report post Posted June 30, 2005 Tahniah.. You are welcome. Quote Share this post Link to post Share on other sites