Search results

You could import it to Excel and then export it to Access. see http://www.ehow.com/how_2240547_get-stock-quotes-excel.html

It had nothing to do with the Locale settings, I used Left() instead of Right (), and the problem I was having with Len() was due to the fact that after the function is called it calls itself again so it really was removing the last chr twice (the first time around the variable is only one chr)...

Thanks, got it!

Added the following: If Num% >= 1000 Then If Len(r$) >= 2 Then r$ = Mid(r$, 1, Len(r$) - 1) & Chr(34) & Mid(r$, Len(r$), 1) End If End If If Len(r$) > 2 Then r$ = Right(r$, Len(r$) - 1) End If Instead of: If Len(r$) >= 2 Then...

Thank you both I solved the mystery!

You're right in English it works but if I replace the English letters in the above code (post #3) with their equivalent in a Hebrew (right to left orientation) it removes both the first and the last letters. I'm totally confused since if I add your debug print lines to the original code when I...

VbaInet, This is what I get; ?Test(5770) before: zy"p after: zy" zy"

yes, I don't understand but it only holds one chr.

How can I change that in the above query? How do I do that?

Here you go: Option Compare Database Function GetGimatrics$(ByVal Num%) Dim r$ Dim Digit% r$ = "" If Num% >= 1000 Then r$ = GetGimatrics$(Num% \ 1000) Num = Num Mod 1000 End If If Num% >= 900 Then r$ = r$ + "zzw" If Num% >= 500 And Num% < 900...

One problem left, if a donor doesn't have record for each the columns (years) that donor won't show up, can that be changed?

Wow! couldn't ask for more!

vbaInet You're amazing. Attached please find a sample mdb, the query I'm struggling with is qryDonations. I also attached a spreadsheet of what I would like the query to look like. Thanks once again.

raskew, This is the only way it works, putting in the string wrapped id double quotation marks. ? Mid("the quick brown fox",1,Len("the quick brown fox")-1) & chr(34) & Mid("the quick brown fox",Len("the quick brown fox"),1) But if I try this it doesn't work ? Mid(r$,1,Len(r$)-1) & chr(34) &...

So I tried this r$ = Mid(r$, 1, Len(r$) - 1) & '"' & Mid(r$,Len(r$),1)" and I got a Compile Error: Expected Expression

Hello to All, I came across a weird issue, with the following statement Left(r$, Len(r$) - 1) It should remove a character from the right (which it does) the problem is that it also removes a character from the left. Any ideas on what caused the problem and how to remedy it will be greatly...

Hello to All, How can I add a double-quotation mark (") before the last chr in a string?

Hey folks I appreciate your input. Privateer, I'd like to see a sample if that's OK with you. stopher (Chris), the query you posted almost does the job, the trouble is that if a donor doesn't have record for each the columns (years) that donor won't show up. btw how can I add other fields to...

Yes, Thanks for your attention time patience and help. The problem I'm having is that I want all 4 columns (one for each year) to show up in 1 line (per donor and have all 4 columns in the same row).

Hello folks, I have a mbd used to track donations made to our organization, I created a query (with the gracious help of vbaInet) that has in addition to the donor's info another four columns to show the donations for the past 3 years + the current year, the trouble I'm experiencing is that the...