Group (not sort) on alpha-numeric text field (1 Viewer)

U

UnrulyJulie

Registered User.

Local time

Today, 03:19

Joined

Jan 29, 2010

Messages

62

• Feb 14, 2013

• #21

Wow. Fixed the missing records on the report. I was staring at it too long. Woke up this morning, one look and DUH - had 2 fields in the same header.

So that part is fixed and all are displaying on the report now, just still have the plt-1 record out of order...

Good grief...

 

Brianwarnock

Retired

Local time

Today, 08:19

Joined

Jun 2, 2003

Messages

12,701

• Feb 14, 2013

• #22

Hi

A-1
plt-1 <------ this is the problem.
D-7

If that is still the result it could be either plt-1 or D-7 that is the problem, but what I can't figure out.

Brian

 

U

UnrulyJulie

Registered User.

Local time

Today, 03:19

Joined

Jan 29, 2010

Messages

62

• Feb 14, 2013

• #23

Hi Brian! I found a solution!!

I still have no idea why your solution didn't work for me. The code in this thread worked perfectly, and will take into account any and all possibly combinations of numbers and letters as well as leading zeros. Wish I had found this sooner - funny how Google algorithms work sometimes. I added the word complex.

http://www.access-programmers.co.uk/forums/showthread.php?t=120275

Thanks again for all of your help!!

 

Brianwarnock

Retired

Local time

Today, 08:19

Joined

Jun 2, 2003

Messages

12,701

• Feb 14, 2013

• #24

Hi Julie,
I'm glad that you have found a solution although it is frustrating to not know why mine did not work for you and did for me the important thing is that you now can move on.

I will be taking a better look at the link and the function when I get time.

Thank you for the feed back

Brian