Access To SQL

  • Thread starter Thread starter mark5 via AccessMonster.com
  • Start date Start date
M

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.
 
Before starting worrying yourself with formating the data, you should think
about how displaying the data in HTML first.
 
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.
 
Back
Top