Odd even

[penguinspeaks]

Ok. I have tried and tried with this. Here is what I need.
I want my html table to display the odd rows in a DB table, like the 1, 3, 5, 7 and so on where say field Rd1 = 1
So it would get all the rows where Rd1 = 1 then display the odd numbered rows based on that criteria.
Is this possible?? Cause I sure cant get it to work.
For info, this is access DB, and I use FP for some.
Let me know if you need more info.
Bammer

 

[JayKusch]

Sounds like you are using an Access database. If this is so, you need to post this question in the Access DB Forum.

Thanks

J. Kusch

 

[penguinspeaks]

Yep. That is the DB I use, but i need this SQL statement on the ASP page itself. But thanks anyway, I will post elsewhere
Bammer

 

[SQLBill]

Jay's not giving you a hard time, this isn't the forum for the SQL language. This is the forum for a particular database - Microsoft SQL Server which uses Transact-SQL (TSQL).

-SQLBill

All SQL isn't created equal. There's Oracle's SQL, Access' SQL, MySQL SQL, SQL Server SQL, SYBASE SQL......



SELECT 'forum' CASE [SQL TYPE]
WHEN 'MySQL' THEN 'forum436'
WHEN 'Access' THEN 'forum700', 'forum701', 'forum702', 'forum703', 'forum704', 'forum181'
WHEN 'ORACLE' THEN 'forum185' 'forum186', 'forum759'

 

[JayKusch]

In deed I was not at all being crass! I just want our fellow members to get the quickest answers from the appropriate forums. Good Luck!

Thanks

J. Kusch

 

[penguinspeaks]

No worries. Thanks for pointing me in the right direction.
Bammer