hi all; I am a new user in any forum.plz help me in my problem. I am using odbc,to connect to access database,making a DSN. I want to access a table having fields client,titles and tariff.Their can be repetiotion of data having same client.i.e their can more occurances of same client. I want to show the all records in the <table> such that the table contain every client name only once and other than tha other fields, there should be a new column in my <table> having header "Downloads" that contain the number of occurences of the coressponding client.i.e the number of a specific client exists in access table named "billing",e.g. ABC is one client and it occurs in table 7 times. the <table> show show once ABC,and against it the number of ABC in table, same to all clients. please help me in this context, I need it badly. Good Luck
If you can export your data to an sql database then I can help, why do you need to use the access database? Does your host have sql support?
Its not my own Software but of my company.So, I have to do as they require. I urgently require solution of this.plz do something if u can do.