Convert query to Access

Question

2.00/5 (3 votes)

See more:

select max(SubString(ColumnName,Len(ColumnName)-1,Len(ColumnName))) from TableName

how to write this type of query in ms access

Hi please send the query in My Sql And also Ms Access

[edit]Don't ask the question in the subject - that should be a brief description to interest those who might know the answer - OriginalGriff[/edit]

Posted 6-Jan-11 1:48am

sandeep sonkar

Updated 6-Jan-11 1:53am

OriginalGriff

v2

Add a Solution

Comments

Rajesh Anuhya 6-Jan-11 8:04am

Try yourself before posting question.., Google is your friend

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Hiren solanki · Answer 1 · 2011-01-06T02:00:00

Solution 2

Select MAX(MID(ColumnName,Len(ColumnName)-1,Len(ColumnName))) from TableName

I've gathered that information from three different access KB pages.

You too have a good review of it.

Mid[^].
Len[^].
Max[^]

Posted 6-Jan-11 2:00am

Hiren solanki

v2

Comments

Rajesh Anuhya 6-Jan-11 8:03am

Good Answer +5

#realJSOP 6-Jan-11 8:20am

Don't spoon-feed them - they won't learn anything.

Hiren solanki 6-Jan-11 8:21am

Thanks john for advice. but OP have asked question like "what is replacement for substring in MS ACCESS" ? that could make sense.

#realJSOP 6-Jan-11 8:24am

It's easily answered with minimal effort on his part. That's my whole point. We're competing for jobs with these lazy "programmers" who can barely pour piss out of a boot even with instructions written on the heel.

Hiren solanki 6-Jan-11 8:33am

That's very well said, john

#realJSOP · Answer 2 · 2011-01-06T01:57:00

Why don't you break the select statement down into its component parts, and google each one? That's what I would have to do to answer your question, and no doubt many others here would have to do as well. For instance, googling "ms access max statement" returns 14.4 MILLION results, amonfg them is this link:

http://www.databasedev.co.uk/access_max_function.html[^]

EDIT ============

Are you down-voting this because I tried to get you to make some sort of effort of your own, or because I didn't spoon-feed you the precise translation? In either case, it indicates poor social skills on your part.