ACCESS HELP, trying to count groups

fbm2themex · Sep 11th, 2007, 23:14

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 · Sep 12th, 2007, 04:37

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

PHP: Select all


<?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 · Sep 12th, 2007, 11:20

Quote:

Originally Posted by c010depunkk

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

PHP: Select all


<?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 · Sep 12th, 2007, 12:03

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