Access To SQL

[mark5 via AccessMonster.com]

I'm converting an Access 2000 database to SQL 2000. In this conversion I will
be creating a Web front end and need to know how to conditionally format HTML
tables based on the results of a query/view in SQL. Example: If dept. A sales
are <= x then format table cell red. If dept A sales >= y then format table
cell green.

Should (can) I attempt to do the formatting in SQL prior to submitting to the
Web HTML table or should I evaluate the HTML table after the results have
been written and format then?

The end result on this is to build a Web based color dashboad based on query
results.

Any help is really appreciated.

 

[Sylvain Lafontaine]

Before starting worrying yourself with formating the data, you should think
about how displaying the data in HTML first.

 

[Brendan Reynolds]

You would apply the formatting in the front-end web-based application. You
will probably do this not *after* the results have been written but *as*
they are written. But the details will depend on what technologies you are
using to build the web-based application.