Simple DB Question

Results 1 to 2 of 2

Thread: Simple DB Question

  1. #1
    Join Date
    Dec 1969

    Default Simple DB Question

    I have a very simple question.<BR>I am having trouble getting my database to spit out the rows<BR>in colors..I would like to have the rows go:<BR>white-grey-white-grey-white-grey...etc..<BR>Does anybody know a basic line of code I can use?<BR>I am running Access DB & SQL DB for this project.<BR><BR>I would appreciate your help.<BR>Thanks soo much<BR><BR>bg

  2. #2
    Join Date
    Dec 1969

    Default RE: Simple DB Question

    Easy - just declare a variable to use as a counter and increment it on every iteration. Then you can use "counter mod 2" to find out if this is an odd-numbered or even-numbered row and write the appropriate colour.<BR><BR>Dunc

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts