firoz.raj
-3
Posting Pro in Training
Recommended Answers
Jump to PostTry this but i am not sure. b'cos i have not tried it myself. get back if any problem.
rscombo.Open "select MAX(MID(item_code,2,10)), ITEM_CODE from production WHERE item_code is not NULL and LEFT(ucase(trim(Production.ITEM_CODE)),1) = 'P' GROUP BY ITEM_CODE "
Jump to Postrscombo.Open "select max(VAL(MID(item_code,2,10))), item_code from production WHERE item_code is not NULL and LEFT(ucase(trim(Production.ITEM_CODE)),1) = 'P' GROUP BY ITEM_CODE ORDER BY VAL(MID(item_code,2,10)) DESC"
All 5 Replies
aktharshaik
16
Posting Whiz
firoz.raj
-3
Posting Pro in Training
aktharshaik
16
Posting Whiz
aktharshaik
16
Posting Whiz
firoz.raj
-3
Posting Pro in Training
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.