ACCESS HELP, trying to count groups

fbm2themex · September 11th, 2007, 07:14 PM

I am trying to count/find the page count. or more like to find how many pages(blankss) are within Y(each Y)..

example:

(Col1) (Col2) (what im trying to get in the nxt col)
1 Y 3
2
3
4 Y 1
5 Y 5
6
7
8
9
10 C 1

Can anyone help me out??

c010depunkk · September 12th, 2007, 12:37 AM

well, if you're using PHP you could use the explode function:

Code:


			
<?php
foreach($rows as $row) {
  $parts=explode('Y',$row);
  // now $parts[0] holds the first number
  // and $parts[1] holds the second number
  // and if $parts is empty (count($parts)==0), then there was only one number
?>

fbm2themex · September 12th, 2007, 07:20 AM

Quote:

Originally Posted by c010depunkk

well, if you're using PHP you could use the explode function:

Code:


			
<?php
foreach($rows as $row) {
  $parts=explode('Y',$row);
  // now $parts[0] holds the first number
  // and $parts[1] holds the second number
  // and if $parts is empty (count($parts)==0), then there was only one number
?>

no, im using access for this..still, this seems way simpler. thanks though, if theres no way to do it in access, il keep this in mind...

c010depunkk · September 12th, 2007, 08:03 AM

Access is a kind of database, not a programming language. You can't split strings in Access...