Recent content by HCL

I have resolved this issue by adding a sort field. This field contains a higher number (5) where there are no leading zeros, a smaller number (4) where there is one leading zero, a smaller number (3) if there are two leading zeros etc. The final query sort is on this field first, then the VAL...

Again, many thanks for all the suggestions. Clearly my solution is going to be the inclusion of many functions.

I appreciate the various comments so will go back to the drawing board. Thanks.

Sorry, but in my ignorance I was hoping that entering a leading zero to the new numbers 01,02,03 etc, the VAL function would sort them first before any of the existing numbers, so that the list would produce 01,02,03 then 1,2 3. But looking at your example of ?val("010") giving 10 implies that...

Is there a problem with the VAL function dealing with leading zeros?

I have a table containing details of parishioners who have died in the parish. The source for this were physical registers which were used to create table entries. Entry numbers existed in the registers and formed part of the details that were created in the "Deaths" table. These entry numbers...

A novice at Access. I use Access 365 and have been involved with minor developments, primarily for my local church. I look forward to reading the wisdom associated with this site.