division of length of field in a query

[zoonkai]

I'm building a query and one of the fields ("imagelist&quot is a reference to an image name. (i.e. 00000125 is one image name) some of them have two and three or more images. I would like to be able to do something like this.

lenght of imagelist / 8 = number of pages..

so
00000125 would return "1"

0000012500000126 would return "2"

000001250000012600000127 would return "3"

any help would be greatly appreciated...

I appreciate all the help everyone has give me lately. Thanx!!

Donald
Donald (Zoonkai) Dixon
donnan@don-nan.com

http://www.don-nan.com

 

[zoonkai]

Figured it out, tried similar syntax as BBx (Business Basic) & walah it worked...

Thanx again Donald (Zoonkai) Dixon
donnan@don-nan.com

http://www.don-nan.com

 

[THoey]

I created a very small function that will display the number of pages:

Public Function fncCntPages(strIn As String)
    Dim intNumPages As Integer
    Dim result As Integer
    
    intNumPages = Len(strIn) / 8
    
    result = MsgBox("The total is " & intNumPages, vbOKOnly)
    
End Function
[code]
You can modify this or just use the idea to help you out...
 Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.

 

[THoey]

Glad you figured it out and sorry I didn't notice you wanted to do this in a query... Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.