Search results

Hello, Not sure I posted to the correct forum, but here goes I would like to import an excel sheet into a new access table. However I am having problems with multiple fields. Lets say for instance that in my excel sheet I have the following fields Field name Name Exam Exam_score Date...

Distinct Query problem Hi, Thanks for the suggestion. For some reason or another group by does not work on this situation. I still get the same results. Here is the SQL code SELECT DISTINCT StuMod.scode, HealthStat.Date, HealthStat.PatientCode, HealthStat.NPOPID, Session.Supervisor FROM...

Hello SQL professionals I am trying to get rid of duplicates in a column instead of the rows using access 2000. For example. Here is what is returned to me without Distinct B 20 A 10 B 40 C 20 D 30 C 10 A 30 Instead I would like something more like this B 20 A 10 C 20 D 30 Can this be...

Data problems on database Well, I think it is a lot less than 2 gig, I reckon around half a gig. I dont think I have compacted the database, just did its suggestions on using long int instead of Text for data names. There is data that is over six months old, however there is other tables...

Hello We have a MS Access 2000 database situated over a Novell Network. However when it comes to entrying data into system within half an hour it crashes, which means the computer begins to just freeze and nothing happends. I have noticed that the amount of records in this database is getting...