Recent content by Chun

Thanks Bob Larson for your help. Appreciate it. The actual database I have is for a hospital system. I have to do some program checks, validation check for the database which has approx 2000 records and about 30 fields. For each groupno, i have to do some validation checks for the different...

Thank you The_Doc_Man for your suggestion. Crosstab query does not help me with my problem. However I tried this query, but the only problem with this is it repeats the records. (I know for sure I am missing only one little thing somewhere, but just cannot seem to trace it out) Pls help me...

Hello Everybody I am trying to set up a query for a table which has following 3 fields GroupNo Name Points which has values in the following manner GroupNo-Name-Points 204-------Jack---- 20 204-------Ryan---40 204-------Tita-----30 202-------Jack----35 202-------Ryan----24...