Recent content by lbcgav

Thank you. I got the query to work according to your instructions. Thank you very much.

Thank you for this explanation. This is what I thought was going on and I did try the Val function but it would not give me the values I needed for the product ids starting with letters. I know this sounds quite elementary, but could someone tell me how to create a function. I found out how...

Thank you for the quick replies. Unfortunately, not all the product ids start with 2 letters. Some are purely numerical, e.g., 2021. Some end with letters. I noticed that I get the same problem in Excel. If I sort the following: 1500, 1200, 500, 200, Excel sorts it as 200, 500, 1200, 1500...

A relative newbie to Access here. I'm tring to sort according to product ID where the product ID is text and often alphanumeric. For example EH1200, EH250, EH2600. Right now, the sort order is EH1200, EH250, EH2600. How can I get it to sort it in the following order: EH250, EH1200, EH2600...