Search results

I've tried both yours and june7 codes and they work upto a point, but they are not counting the numbers with a leading zero. i changed the format to '00000' on the numbers field but it did'nt make any difference

they are to be primarily treated as numbers, the reason they are text is so they display in a text box as they are in typed in the table, if i change the field type to number, it deletes the leading zero

All i get is an #Name? in the text box

you're right, the addnumber type was short text, let me explain further, the table consists of numbers from 03001 to 89500, which is why i had to put the type as short text, so it would except the numbers starting with a '0', is there a way of writing the code so it works with numbers starting...

all it says in the text box is #Error

Hi, i'm trying to count the numbers between 60001 and 60061 with dcount and put the result in a text box, but all i get is an error, this is the code i'm using .... =DCount("*","[ALL]","[AddNumber] >= 60001 And [AddNumber] <= 60061")