Search results

Many thanks to all who contributed to my query. I used the suggestion from MajP and it has worked a treat. I very much appreciate the time you all spent in answering my request. Thank you.

I'm sorry if this has already been asked. I am printing out a quiz sheet and want to print out a series of underscores, alongside the question, that represents the length of the answer. For example, for the State Capital of Alabama to produce __________ (10 underscores for the answer...

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.