Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > access > answers

Grouping Numbers

  #1  
Old October 23rd, 2007, 11:38 PM
Member
  
Join Date: Oct 2007
Posts: 33
Hi..

I have a set of numbers that are not sequential. For example, 1, 2, 3, 4, 6,7,8,9,10,14,15.

I have tried to use the FIRST/LAST and MIN/MAX in QUERY but it didn't work. It will return 1 and 15.

How do I get results returned as (1,4), (6,10) and (14,15)?

VB codes or SQL would be great!

Cheers!
Clarence
  #2  
Old October 23rd, 2007, 11:51 PM
FishVal's Avatar
Expert
  
Join Date: Jun 2007
Location: Israel
Posts: 2,585
Provided Answers: 8

re: Grouping Numbers

Hi, Clarence.

Clarify please what do you actually want to do with these "groups".
  #3  
Old October 24th, 2007, 02:45 AM
Member
  
Join Date: Oct 2007
Posts: 33

re: Grouping Numbers

Hi FishVal,

Thanks for your reply.

Please let me elaborate.

I have two fields named LEVEL and BIN_NO (see below).

LEVEL BIN_NO
A 1
A 2
A 3
A 5
A 6
A 7
B 1
B 2
B 3
B 4
B 8
B 9
B 10

I would like the query to return results as follow.

LEVEL BIN_NO
A 1 to 3
A 5 to 7
B 1 to 4
B 8 to 10

The results will be used to inform user specifically which level/bin contained items in it.

Cheers!
Clarence


Quote:
Originally Posted by FishVal
Hi, Clarence.

Clarify please what do you actually want to do with these "groups".
  #4  
Old October 24th, 2007, 03:07 AM
FishVal's Avatar
Expert
  
Join Date: Jun 2007
Location: Israel
Posts: 2,585
Provided Answers: 8

re: Grouping Numbers

Quote:
Originally Posted by clarencelai
Hi FishVal,

Thanks for your reply.

Please let me elaborate.

I have two fields named LEVEL and BIN_NO (see below).

LEVEL BIN_NO
A 1
A 2
A 3
A 5
A 6
A 7
B 1
B 2
B 3
B 4
B 8
B 9
B 10

I would like the query to return results as follow.

LEVEL BIN_NO
A 1 to 3
A 5 to 7
B 1 to 4
B 8 to 10

The results will be used to inform user specifically which level/bin contained items in it.

Cheers!
Clarence
Hi, Clarence.

I have something like this in one of my projects.
It will return you

LEVEL BIN_NO
A 1 to 3, 5 to 7
B 1 to 4, 8 to 10

Place the following function in a code module.
Expand|Select|Wrap|Line Numbers
  1. Public Function BinSummary(ByVal strLevel As Variant) As String
  2.  
  3.     Dim RS As New ADODB.Recordset
  4.     Dim lngBinNo As Long
  5.     Dim strSQL as String
  6.  
  7.     If IsNull(strLevel) Then Exit Function
  8.  
  9.     lngBinNo = -1
  10.  
  11.     strSQL="SELECT BIN_NO FROM tblYourTable WHERE LEVEL='" & _
  12.         strLevel & "';"
  13.  
  14.     With RS
  15.         .ActiveConnection = CurrentProject.Connection
  16.         .CursorType = adOpenForwardOnly
  17.         .LockType = adLockReadOnly
  18.         .Open strSQL
  19.         While Not .EOF
  20.             If lngBinNo + 1 = ![BIN_NO] Then
  21.                 If Right(BinSummary, 1) <> " to " Then _
  22.                     BinSummary = BinSummary & "-"
  23.             Else
  24.                 If Right(BinSummary, 1) = " to " Then _
  25.                     BinSummary = BinSummary & lngBinNo
  26.                 BinSummary = BinSummary & ", " & ![BIN_NO]
  27.             End If
  28.             lngStockPrepID = ![BIN_NO]
  29.             .MoveNext
  30.         Wend
  31.         .Close
  32.     End With
  33.  
  34.     If Right(BinSummary, 1) = " to " Then _
  35.                     BinSummary = BinSummary & lngBinNo
  36.     BinSummary = Right(BinSummary, Len(BinSummary) - 2)
  37.  
  38.     Set RS = Nothing
  39.  
  40. End Function
  41.  
  42.  
And run the following query.

Expand|Select|Wrap|Line Numbers
  1. SELECT tblYourTable.LEVEL, PrepStocksSummary(tblYourTable.LEVEL) AS txtBinSummary
  2. FROM tblYourTable
  3. GROUP BY tblYourTable.LEVEL;
  4.  
  #5  
Old October 24th, 2007, 07:32 AM
Member
  
Join Date: Oct 2007
Posts: 33

re: Grouping Numbers

Hi FishVal,

It seems like "PrepStocksSummary" was not defined.

Cheers!
Clarence


Quote:
Originally Posted by FishVal
Hi, Clarence.

I have something like this in one of my projects.
It will return you

LEVEL BIN_NO
A 1 to 3, 5 to 7
B 1 to 4, 8 to 10

Place the following function in a code module.
Expand|Select|Wrap|Line Numbers
  1. Public Function BinSummary(ByVal strLevel As Variant) As String
  2.  
  3.     Dim RS As New ADODB.Recordset
  4.     Dim lngBinNo As Long
  5.     Dim strSQL as String
  6.  
  7.     If IsNull(strLevel) Then Exit Function
  8.  
  9.     lngBinNo = -1
  10.  
  11.     strSQL="SELECT BIN_NO FROM tblYourTable WHERE LEVEL='" & _
  12.         strLevel & "';"
  13.  
  14.     With RS
  15.         .ActiveConnection = CurrentProject.Connection
  16.         .CursorType = adOpenForwardOnly
  17.         .LockType = adLockReadOnly
  18.         .Open strSQL
  19.         While Not .EOF
  20.             If lngBinNo + 1 = ![BIN_NO] Then
  21.                 If Right(BinSummary, 1) <> " to " Then _
  22.                     BinSummary = BinSummary & "-"
  23.             Else
  24.                 If Right(BinSummary, 1) = " to " Then _
  25.                     BinSummary = BinSummary & lngBinNo
  26.                 BinSummary = BinSummary & ", " & ![BIN_NO]
  27.             End If
  28.             lngStockPrepID = ![BIN_NO]
  29.             .MoveNext
  30.         Wend
  31.         .Close
  32.     End With
  33.  
  34.     If Right(BinSummary, 1) = " to " Then _
  35.                     BinSummary = BinSummary & lngBinNo
  36.     BinSummary = Right(BinSummary, Len(BinSummary) - 2)
  37.  
  38.     Set RS = Nothing
  39.  
  40. End Function
  41.  
  42.  
And run the following query.

Expand|Select|Wrap|Line Numbers
  1. SELECT tblYourTable.LEVEL, PrepStocksSummary(tblYourTable.LEVEL) AS txtBinSummary
  2. FROM tblYourTable
  3. GROUP BY tblYourTable.LEVEL;
  4.  
  #6  
Old October 24th, 2007, 07:53 AM
FishVal's Avatar
Expert
  
Join Date: Jun 2007
Location: Israel
Posts: 2,585
Provided Answers: 8

re: Grouping Numbers

Quote:
Originally Posted by clarencelai
Hi FishVal,

It seems like "PrepStocksSummary" was not defined.

Cheers!
Clarence
It seems like you just copypasted code without making an effort to understand it's logic.
I picked it from working db and replaced names with your ones. No wonder I missed to replace some (1 in function and 1 in query).

BTW the code was adapted on-fly w/o testing, I don't guarantee it will work as is.
Below is fixed variant.

Expand|Select|Wrap|Line Numbers
  1. Public Function BinSummary(ByVal strLevel As Variant) As String
  2.  
  3.     Dim RS As New ADODB.Recordset
  4.     Dim lngBinNo As Long
  5.     Dim strSQL as String
  6.  
  7.     If IsNull(strLevel) Then Exit Function
  8.  
  9.     lngBinNo = -1
  10.  
  11.     strSQL="SELECT BIN_NO FROM tblYourTable WHERE LEVEL='" & _
  12.         strLevel & "' ORDER BY BIN_NO;"
  13.  
  14.     With RS
  15.         .ActiveConnection = CurrentProject.Connection
  16.         .CursorType = adOpenForwardOnly
  17.         .LockType = adLockReadOnly
  18.         .Open strSQL
  19.         While Not .EOF
  20.             If lngBinNo + 1 = ![BIN_NO] Then
  21.                 If Right(BinSummary, 1) <> " to " Then _
  22.                     BinSummary = BinSummary & " to "
  23.             Else
  24.                 If Right(BinSummary, 1) = " to " Then _
  25.                     BinSummary = BinSummary & lngBinNo
  26.                 BinSummary = BinSummary & ", " & ![BIN_NO]
  27.             End If
  28.             lngBinNo = ![BIN_NO]
  29.             .MoveNext
  30.         Wend
  31.         .Close
  32.     End With
  33.  
  34.     If Right(BinSummary, 1) = " to " Then _
  35.                     BinSummary = BinSummary & lngBinNo
  36.     BinSummary = Right(BinSummary, Len(BinSummary) - 2)
  37.  
  38.     Set RS = Nothing
  39.  
  40. End Function
  41.  
  42.  

Expand|Select|Wrap|Line Numbers
  1. SELECT tblYourTable.LEVEL, BinSummary(tblYourTable.LEVEL) AS txtBinSummary
  2. FROM tblYourTable
  3. GROUP BY tblYourTable.LEVEL;
  4.  
Last edited by FishVal; October 24th, 2007 at 08:03 AM. Reason: code fixed
  #7  
Old October 24th, 2007, 09:28 AM
Member
  
Join Date: Oct 2007
Posts: 33

re: Grouping Numbers

Hi FishVal,

Thanks for your email and further explanation.

I did not simply cut n paste without making changes to your code.

I must say I do not understand the code 100% though.

All the field names are replaced with the correct ones in my table for the purpose of my query.

However, I must admit that I do not understand why there was undefined "PrepStocksSummary" function there. In fact, I did replace them with BinSummary but it return some strange results as well.

Now, to isolate and confirm if your codes work, I created "tblYourTable" with LEVEL and BIN_NO as the exact field names.

The query returns the following results

A 1 to to to , 6 to to to to to
B 1 to to , 8 to to

I would appreciate if you could assist me further.

Cheers!
Clarence
PS: I am a beginner to programming and not very familiar with VB codes. I am keen to learn though. :-o)


Quote:
Originally Posted by FishVal
It seems like you just copypasted code without making an effort to understand it's logic.
I picked it from working db and replaced names with your ones. No wonder I missed to replace some (1 in function and 1 in query).

BTW the code was adapted on-fly w/o testing, I don't guarantee it will work as is.
Below is fixed variant.

Expand|Select|Wrap|Line Numbers
  1. Public Function BinSummary(ByVal strLevel As Variant) As String
  2.  
  3.     Dim RS As New ADODB.Recordset
  4.     Dim lngBinNo As Long
  5.     Dim strSQL as String
  6.  
  7.     If IsNull(strLevel) Then Exit Function
  8.  
  9.     lngBinNo = -1
  10.  
  11.     strSQL="SELECT BIN_NO FROM tblYourTable WHERE LEVEL='" & _
  12.         strLevel & "' ORDER BY BIN_NO;"
  13.  
  14.     With RS
  15.         .ActiveConnection = CurrentProject.Connection
  16.         .CursorType = adOpenForwardOnly
  17.         .LockType = adLockReadOnly
  18.         .Open strSQL
  19.         While Not .EOF
  20.             If lngBinNo + 1 = ![BIN_NO] Then
  21.                 If Right(BinSummary, 1) <> " to " Then _
  22.                     BinSummary = BinSummary & " to "
  23.             Else
  24.                 If Right(BinSummary, 1) = " to " Then _
  25.                     BinSummary = BinSummary & lngBinNo
  26.                 BinSummary = BinSummary & ", " & ![BIN_NO]
  27.             End If
  28.             lngBinNo = ![BIN_NO]
  29.             .MoveNext
  30.         Wend
  31.         .Close
  32.     End With
  33.  
  34.     If Right(BinSummary, 1) = " to " Then _
  35.                     BinSummary = BinSummary & lngBinNo
  36.     BinSummary = Right(BinSummary, Len(BinSummary) - 2)
  37.  
  38.     Set RS = Nothing
  39.  
  40. End Function
  41.  
  42.  

Expand|Select|Wrap|Line Numbers
  1. SELECT tblYourTable.LEVEL, BinSummary(tblYourTable.LEVEL) AS txtBinSummary
  2. FROM tblYourTable
  3. GROUP BY tblYourTable.LEVEL;
  4.  
  #8  
Old October 24th, 2007, 10:52 AM
FishVal's Avatar
Expert
  
Join Date: Jun 2007
Location: Israel
Posts: 2,585
Provided Answers: 8

re: Grouping Numbers

Hi, Clarence.

As I've said the code was changed on-fly without testing.
Below are the further fixes and some comments. Hope this will work.
Expand|Select|Wrap|Line Numbers
  1. Public Function BinSummary(ByVal strLevel As Variant) As String
  2.  
  3.     Dim RS As New ADODB.Recordset
  4.     Dim lngBinNo As Long
  5.     Dim strSQL as String
  6.  
  7.     If IsNull(strLevel) Then Exit Function
  8.  
  9.     lngBinNo = -1
  10.  
  11.     'retrieve BIN_NO related to particular LEVEL in ascending order
  12.     strSQL="SELECT BIN_NO FROM tblYourTable WHERE LEVEL='" & _
  13.         strLevel & "' ORDER BY BIN_NO;"
  14.  
  15.     With RS
  16.         '----------- Open recordset to get records
  17.         .ActiveConnection = CurrentProject.Connection
  18.         .CursorType = adOpenForwardOnly
  19.         .LockType = adLockReadOnly
  20.         .Open strSQL
  21.         '-------------------------------------------------
  22.         '--------loop through retrieved records
  23.         While Not .EOF
  24.             '----if current BIN_NO = previous+1 then add to output " to " if not yet
  25.             If lngBinNo + 1 = ![BIN_NO] Then
  26.                 If Right(BinSummary, 4) <> " to " Then _
  27.                     BinSummary = BinSummary & " to "
  28.             '---- if not so add comma and BIN_NO as is
  29.             Else
  30.                 If Right(BinSummary, 4) = " to " Then _
  31.                     BinSummary = BinSummary & lngBinNo
  32.                 BinSummary = BinSummary & ", " & ![BIN_NO]
  33.             End If
  34.             '---store current BIN_NO to compare with the next one (see above)
  35.             lngBinNo = ![BIN_NO]
  36.             .MoveNext
  37.         Wend
  38.         .Close
  39.     End With
  40.  
  41.     '------- finalize output
  42.     If Right(BinSummary, 4) = " to " Then _
  43.                     BinSummary = BinSummary & lngBinNo
  44.     BinSummary = Right(BinSummary, Len(BinSummary) - 2)
  45.  
  46.     Set RS = Nothing
  47.  
  48. End Function
  49.  
  50.  
  #9  
Old October 24th, 2007, 05:22 PM
Member
  
Join Date: Oct 2007
Posts: 33

re: Grouping Numbers

Hi FishVal,

Thank you so much!

The code works on a fly!

Pardon me but I have one more request.

Now, if there is another level above LEVEL, how can the codes be modified to suit the need? For example, if I need to further break down by the rack number (RACK_NO), how can the code be modified to suit the need?

RACK_NO ==> LEVEL ==> BIN_NO

Rack_No LEVEL BIN_NO
AA , A, 1
AA , A, 2
AA , A, 3
BB , A, 1
BB , A, 2
BB , A, 3
BB , A, 4


Desired returned results would be..

AA, A, 1 to 3
BB, A, 1 to 4

Appreciate your advice.


Best Regards,
Clarence


Quote:
Originally Posted by FishVal
Hi, Clarence.

As I've said the code was changed on-fly without testing.
Below are the further fixes and some comments. Hope this will work.
Expand|Select|Wrap|Line Numbers
  1. Public Function BinSummary(ByVal strLevel As Variant) As String
  2.  
  3.     Dim RS As New ADODB.Recordset
  4.     Dim lngBinNo As Long
  5.     Dim strSQL as String
  6.  
  7.     If IsNull(strLevel) Then Exit Function
  8.  
  9.     lngBinNo = -1
  10.  
  11.     'retrieve BIN_NO related to particular LEVEL in ascending order
  12.     strSQL="SELECT BIN_NO FROM tblYourTable WHERE LEVEL='" & _
  13.         strLevel & "' ORDER BY BIN_NO;"
  14.  
  15.     With RS
  16.         '----------- Open recordset to get records
  17.         .ActiveConnection = CurrentProject.Connection
  18.         .CursorType = adOpenForwardOnly
  19.         .LockType = adLockReadOnly
  20.         .Open strSQL
  21.         '-------------------------------------------------
  22.         '--------loop through retrieved records
  23.         While Not .EOF
  24.             '----if current BIN_NO = previous+1 then add to output " to " if not yet
  25.             If lngBinNo + 1 = ![BIN_NO] Then
  26.                 If Right(BinSummary, 4) <> " to " Then _
  27.                     BinSummary = BinSummary & " to "
  28.             '---- if not so add comma and BIN_NO as is
  29.             Else
  30.                 If Right(BinSummary, 4) = " to " Then _
  31.                     BinSummary = BinSummary & lngBinNo
  32.                 BinSummary = BinSummary & ", " & ![BIN_NO]
  33.             End If
  34.             '---store current BIN_NO to compare with the next one (see above)
  35.             lngBinNo = ![BIN_NO]
  36.             .MoveNext
  37.         Wend
  38.         .Close
  39.     End With
  40.  
  41.     '------- finalize output
  42.     If Right(BinSummary, 4) = " to " Then _
  43.                     BinSummary = BinSummary & lngBinNo
  44.     BinSummary = Right(BinSummary, Len(BinSummary) - 2)
  45.  
  46.     Set RS = Nothing
  47.  
  48. End Function
  49.  
  50.  
  #10  
Old October 24th, 2007, 06:09 PM
FishVal's Avatar
Expert
  
Join Date: Jun 2007
Location: Israel
Posts: 2,585
Provided Answers: 8

re: Grouping Numbers

Quote:
Originally Posted by clarencelai
Hi FishVal,

Thank you so much!

The code works on a fly!

Pardon me but I have one more request.

Now, if there is another level above LEVEL, how can the codes be modified to suit the need? For example, if I need to further break down by the rack number (RACK_NO), how can the code be modified to suit the need?

RACK_NO ==> LEVEL ==> BIN_NO

Rack_No LEVEL BIN_NO
AA , A, 1
AA , A, 2
AA , A, 3
BB , A, 1
BB , A, 2
BB , A, 3
BB , A, 4


Desired returned results would be..

AA, A, 1 to 3
BB, A, 1 to 4

Appreciate your advice.


Best Regards,
Clarence
Hi, Clarence.

Glad you've got it working.
Concerning your further question I would like to say - "exactly the same way but using two fields in the query grouping and filter criteria in BinSummary".

Smthng like this:

Expand|Select|Wrap|Line Numbers
  1. SELECT tblYourTable.RACK_NO, tblYourTable.LEVEL, BinSummary(tblYourTable.RACK_NO, tblYourTable.LEVEL) AS txtBinSummary
  2. FROM tblYourTable
  3. GROUP BY tblYourTable.RACK_NO, tblYourTable.LEVEL;
  4.  
Expand|Select|Wrap|Line Numbers
  1. Public Function BinSummary(ByVal strRackNo as Variant, _
  2.                                            ByVal strLevel As Variant) As String
  3.  
  4.     Dim RS As New ADODB.Recordset
  5.     Dim lngBinNo As Long
  6.     Dim strSQL as String
  7.  
  8.     If IsNull(strLevel) Or IsNull(strRackNo) Then Exit Function
  9.  
  10.     lngBinNo = -1
  11.  
  12.     'retrieve BIN_NO related to particular LEVEL in ascending order
  13.     strSQL="SELECT BIN_NO FROM tblYourTable WHERE LEVEL='" & _
  14.         strLevel & "' AND RACK_NO='" & strRackNo & "' ORDER BY BIN_NO;"
  15.  
  16.     With RS
  17.         '----------- Open recordset to get records
  18.         .ActiveConnection = CurrentProject.Connection
  19.         .CursorType = adOpenForwardOnly
  20.         .LockType = adLockReadOnly
  21.         .Open strSQL
  22.         '-------------------------------------------------
  23.         '--------loop through retrieved records
  24.         While Not .EOF
  25.             '----if current BIN_NO = previous+1 then add to output " to " if not yet
  26.             If lngBinNo + 1 = ![BIN_NO] Then
  27.                 If Right(BinSummary, 4) <> " to " Then _
  28.                     BinSummary = BinSummary & " to "
  29.             '---- if not so add comma and BIN_NO as is
  30.             Else
  31.                 If Right(BinSummary, 4) = " to " Then _
  32.                     BinSummary = BinSummary & lngBinNo
  33.                 BinSummary = BinSummary & ", " & ![BIN_NO]
  34.             End If
  35.             '---store current BIN_NO to compare with the next one (see above)
  36.             lngBinNo = ![BIN_NO]
  37.             .MoveNext
  38.         Wend
  39.         .Close
  40.     End With
  41.  
  42.     '------- finalize output
  43.     If Right(BinSummary, 4) = " to " Then _
  44.                     BinSummary = BinSummary & lngBinNo
  45.     BinSummary = Right(BinSummary, Len(BinSummary) - 2)
  46.  
  47.     Set RS = Nothing
  48.  
  49. End Function
  50.  
  51.  
  #11  
Old October 25th, 2007, 05:13 PM
Member
  
Join Date: Oct 2007
Posts: 33

re: Grouping Numbers

Hi Fish Val,

It works! It works!

Thank you so much for your help!

Cheers!
Clarence




Quote:
Originally Posted by FishVal
Hi, Clarence.

Glad you've got it working.
Concerning your further question I would like to say - "exactly the same way but using two fields in the query grouping and filter criteria in BinSummary".

Smthng like this:

Expand|Select|Wrap|Line Numbers
  1. SELECT tblYourTable.RACK_NO, tblYourTable.LEVEL, BinSummary(tblYourTable.RACK_NO, tblYourTable.LEVEL) AS txtBinSummary
  2. FROM tblYourTable
  3. GROUP BY tblYourTable.RACK_NO, tblYourTable.LEVEL;
  4.  
Expand|Select|Wrap|Line Numbers
  1. Public Function BinSummary(ByVal strRackNo as Variant, _
  2.                                            ByVal strLevel As Variant) As String
  3.  
  4.     Dim RS As New ADODB.Recordset
  5.     Dim lngBinNo As Long
  6.     Dim strSQL as String
  7.  
  8.     If IsNull(strLevel) Or IsNull(strRackNo) Then Exit Function
  9.  
  10.     lngBinNo = -1
  11.  
  12.     'retrieve BIN_NO related to particular LEVEL in ascending order
  13.     strSQL="SELECT BIN_NO FROM tblYourTable WHERE LEVEL='" & _
  14.         strLevel & "' AND RACK_NO='" & strRackNo & "' ORDER BY BIN_NO;"
  15.  
  16.     With RS
  17.         '----------- Open recordset to get records
  18.         .ActiveConnection = CurrentProject.Connection
  19.         .CursorType = adOpenForwardOnly
  20.         .LockType = adLockReadOnly
  21.         .Open strSQL
  22.         '-------------------------------------------------
  23.         '--------loop through retrieved records
  24.         While Not .EOF
  25.             '----if current BIN_NO = previous+1 then add to output " to " if not yet
  26.             If lngBinNo + 1 = ![BIN_NO] Then
  27.                 If Right(BinSummary, 4) <> " to " Then _
  28.                     BinSummary = BinSummary & " to "
  29.             '---- if not so add comma and BIN_NO as is
  30.             Else
  31.                 If Right(BinSummary, 4) = " to " Then _
  32.                     BinSummary = BinSummary & lngBinNo
  33.                 BinSummary = BinSummary & ", " & ![BIN_NO]
  34.             End If
  35.             '---store current BIN_NO to compare with the next one (see above)
  36.             lngBinNo = ![BIN_NO]
  37.             .MoveNext
  38.         Wend
  39.         .Close
  40.     End With
  41.  
  42.     '------- finalize output
  43.     If Right(BinSummary, 4) = " to " Then _
  44.                     BinSummary = BinSummary & lngBinNo
  45.     BinSummary = Right(BinSummary, Len(BinSummary) - 2)
  46.  
  47.     Set RS = Nothing
  48.  
  49. End Function
  50.  
  51.  
  #12  
Old October 25th, 2007, 05:27 PM
FishVal's Avatar
Expert
  
Join Date: Jun 2007
Location: Israel
Posts: 2,585
Provided Answers: 8

re: Grouping Numbers

Quote:
Originally Posted by clarencelai
Hi Fish Val,

It works! It works!

Thank you so much for your help!

Cheers!
Clarence
Not a problem. You are welcome.

Best regards,
Fish
Reply

« previous question | next question »

Similar Threads
Thread Thread Starter Forum Replies Last Post
Grouping numbers Chris answers 5 March 6th, 2007 02:05 AM
Grouping numbers Chris answers 12 March 4th, 2007 08:45 PM
Algorithm for Grouping Numbers (Making Teams) a answers 16 November 20th, 2005 04:09 AM

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 225,662 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved