Search results
-
K
Case sensitivity problem in a join
Access cannot tell the difference between O≥06Ç÷ÖID and O≥06Ç÷öID I've tried StrComp but it doesn't work on the non-standard characters. Is there any other way to work around this? Thanks in advance. Ken -
K
Splitting a field where letters start and numbers follow
In my conversion project I must make sense out of uncontrolled course coding. One field is going to become two. There are many variations but the major ones would be like this (X's mean letters and 0's mean numbers): XXX000 XXX 000 XXXX000 XXXX 000 XX00 XX 00 XX0000 etc. I believe there are... -
K
Cumulative total function behaving strangely
I just found this forum, so I hope I'm in the right place and someone can help me. I am converting data for an educational institution and I need to supply a class rank (freshman, sophomore) based on the earned credits. The old database doesn't have the class rank, and the new database...