MS Access Query Insert HTML between Data

[phaxmohdem]

I've been fighting this ghetto database I have to use for an alumni web directory at my job at my school. I need to be able to extract the data from a table and insert HTML tags between the extracted date to form an HTML Table row... (I've figured this part out already). HOWEVER I also need this query to generate alternating table row colors:

In the first tag of every HTML line (The (TR) tag I need it to alternate from (TR bgcolor="#FFFFFF") to (tr bgcolor="#DDF3E7") So just changing the 6 character Hex color code on every other line.

What really ticks me off is that I can do this easily with a small php script, however the computing powers that be on campus will not allow the individual departments, to use databases and advances scripting languages for their pages.. The reason I"m trying to do it in Access is because:
a) the DB is already in Access, and has been for many years... It is the central Alumni DB that our department grabs data from for its purposes.
b) an Access query would be much easier for future webmasters to upkeep and use than a PHP script. (Most students here webmastering just know how to make/edit HTML with dreamweaver, and thats about it unfortunately)

The final web page that this query will be used for can be seen here: http://www.nwmissouri.edu/dept/ctl/alumni/directoryaz.html AS you can see from the navigation on the right, I will also need queries to seperate alumni by decades (I think I know how to do this though)

Hope you can help me out here. Thanks guys.

(Here is what my query looks like right now, simply grabing the data and shoving HTML inbetween the tags)

string: "(tr)(td)" & [DegreeYear] & "(td)" & [LastName] & "(td)" & [FirstName] & "(td)" & [Employer] & "(td)" & [Occupation] & "(td)" & [Major] & "(td)(/tr)"

NOTE: I had to change the angle brackets in the above HTML to Parentheses to be able to post...

 

[rob1234]

This should work.

create a new autonumber field (after sorting the table however the results are supposed to be sorted) and a new text field in your table say 'id' and 'color'. Then use two update queries like so.

Update tablename SET color = 'FFFFFF' WHERE id mod 2 = 0 and
Update tablename SET color = 'DDF3E7' WHERE id mod 2 = 1

then the string would be something like
string: "(tr brcolor='#[color]')(td)" & [DegreeYear] & "(td)" & [LastName] & "(td)" & [FirstName] & "(td)" & [Employer] & "(td)" & [Occupation] & "(td)" & [Major] & "(td)(/tr)"