A for first record b for second and so on.

[angie]

I need to have a column in a query to add a letter starting with A for each record that the query shows. Example. Column one is "address" column two is "city" column three is "zip" I would like column four to be the column that would start with "A" first record than "B" and so on, it would be auto generated starting with "A" I do not need to save this as a field in the table . Thank you Angie.

[orange]

Can you give some sample data showing some input data and the expected output for that data? If you don't need to save it, can you tell us more about Why you need this?

[ItsMe]

I found some code on an Excel forum that I refactored for an Access function. Don't recall exactly where from though.

Function fNextLetter(strRef As String) As String
'Convert to uppercase
strRef = StrConv(strRef, vbProperCase)

Dim T As Variant
If Asc(strRef) >= 65 And Asc(strRef) <= 89 Then     'Considers Letters A - Y (Not Z)
T = Asc(strRef)
T = T + 1
T = Chr(T)
Else    'We are unable to continue
End If
fNextLetter = T

End Function

[angie]

Google Maps Angies.zip

Thanks I have this problem fixed, now I have a Script Problem when I click on the Google Map button, also I would like to have control over the map so that I could reposition or zoom in or out. Thanks everyone. Angie
I have attached a sample of my program the basic when you open it will go to the schedule and if you click show all calls and than the google map button it will open another form which you will click on google map and than you will see the script error and see the addressed ploted but can not zoom in or out no map control.

[ItsMe]

Perhaps that question deserves its own thread. I recommend focusing on the error itself. Perhaps you can post the code that errors in a new thread.

[orange]

@Angie,

When you post questions and through the process you solve an issue, it is helpful to others if you would post the solution.
We're glad you solved the issue. But others who may have a similar problem in future, could benefit from your solution
-- if you had posted same.

[June7]

There is already a thread with that question https://www.accessforums.net/forms/g...lem-46202.html

[angie]

Sorry, I am new at all of this. I don't know how to explain it but if you open the zip file and look at the map list query you will see the coding I used to have google map open and show only the calls I have selected. Its also like a query I use to select dates and employees to filter a schedule form. The example is just a very small part of my database that we use for service in our company. The google map when it opens still has a script error that I can not figure out and also can not zoom in or out or reposition the map which I am working on to try and correct. Thanks Angie. I posted a new post as some said to do so above.