Complex Queried Data Publish to Web Page

Databases
1

I have a complex median parameter query in MS Access 2003.

Currently I display the results, nine columns, about 45 rows in a report.

What I really need is to have this data display to a web page.

I guess from what I read that using tables in web page design is frowned upon.

I have no idea on how to start and my HTML/CSS knowledge is nil.

Direction please . . .

Thanks.

Rick

2

not if what you’re displaying is actual tabular data

in that case, the use of the html TABLE tag is definitely advised

3

Hi Rudy - yep, it’s your query design.

I understand columns and rows.

How is tabular data different?

Rick

4

Okay - I look up HTML <table> tag.

Each time I run the query do I have to hand type all of the column names in, and the data also?

5

different from query output? it isn’t

different from web page layouts? don’t go there :slight_smile:

6

no, the resuts of the query would be inserted within TD tags by your web application language (asp, php, whatever)

7

I have heard of these and recognize that they have to do with data.

Any idea which is the better - or in my case, easier?

Thanks Rudy.

Rick

8

any programming background? VB, perhaps? then use asp

9

A quick search says ASP is for professionals and PHP for homies like me.

I am not looking for interactive abilities from web site visitors.

I just wish to display my Access data on my web pages.

I use many charts on my web site (www.propertiesWithStyle.com) but I first have to convert them to .jpg images and then upload them.

My wish is to generate the chart data, upload that data and display a crystal clear chart on a web page.

I found a program that may do that well, TABLAOU. I also hear that Google has free charting abilities.

Thanks.

Rick

10

I’m in the same boat, I’m building Investing Charts as a service, using ASP.NET/SQL Server/Silverlight. Anyways, is Access your only option? SQL Server Express is free and does a much better job then Access, especially for complex query’s such as chart data. Also, you will be wanting to use ASP.NET, as ASP Classic is ancient and drop in 2001. Their are many more options you need to look into, but I would start by researching ASP.NET and SQL Server Express.