number criteria

[goju]

i have a six digit roling number, (100565)

i have a totals query trying to add the amount of entries are in this query, however i need a criteria for it to look for a six digit number

unless i have this criteria it returns 1 for 100565, and 1 for 100566 and so on

any ideas searching db now

 

[WayneRyan]

goju,

???

It sounds like your number is a string!

If it's a string, use Criteria: Len([YourField]) = 6

If it's a number, use Criteria: Len(CStr([YourField])) = 6

Wayne