could someone provide me with the sql for the following code:

Dim i As Integer
Dim countvar As Integer

If Number_of_Panels.Text > 1 And Number_of_Panels.Text < 27 Then
For i = 1 To Number_of_Panels.Text
countvar = (countvar + 1)
Project_Number.SetFocus
MsgBox Project_Number.Text & countvar
Number_of_Panels.SetFocus


Next i

Else

End If

i'd be very grateful for any help.
thanx in advance
mick

ARE YOU TRYING TO GET THE TOTAL AMOUNT OF RECORDS THAT ARE GREATER THAN 1 AND LESS THAN 27. is that all? I don't quite understand what you want out of the equation.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.