Search results

The target is an Oracle database. The source is a dbf database (foxpro) that loads easily into Access. But the problem is the source databases hex key field. If you're interested I'll let you know how Oracle handles the key. Ken

Well on further reading, I'm finding that I am indeed using the binary compare. This is my field definition: StrComp([field1],[field2],0) According to Access help, the 0 is using the vbBinaryCompare. For some reason those two values are still equal in an Access join. I really did not want...

Ben, It must be. I'm using Access 2002. Sorry about that. I hope someone else can help you work on it, though with an earlier version. Ken

Change InStr to InStrRev Ken

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

In my example, Expr1 will be the query field label (I wasn't sure if PROFIT MARGIN SCORE (200) is a field label, so I used my own example). In my example, ProfMarg stands in for the calculation that must be in the range of zero to 200. It's the IIf statement that first tests for a less than...

I have done this before, but I know there are some good programmers around here. Expr1: IIf([ProfMarg]<0,0,IIf([ProfMarg]>200,200,[ProfMarg])) Ken

Thanks very much, RichO. I put the function calls in a query which I can either put in a static table or just join when I'm doing the final convert. So the "for - exit for" loop will execute in full on the input field?! That suggests other things for me. :) Thanks again! Ken

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...

Thank you! MStef, thank you! I am getting what I want now. Here's the kicker. My code works, too, but certainly not as efficiently as yours. When I look at the the output directly from running the query, the data is wrong. However, if I make it an append query, the data goes into the table...

my running sum must start over many times I took a look at the database, but I need more functionality. I need a running sum or cumulative total for each student, so the running sum must start over when the ID for the student changes. My function seems to have the right logic, but fails to...

Not elegant, but it might work... This might work: week2: IIf([weekfield]<10,"0" & ([weekfield]),[weekfield]) Ken

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...