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
r937
November 18, 2010, 5:43pm
2
not if what you’re displaying is actual tabular data
in that case, the use of the html TABLE tag is definitely advised
Hi Rudy - yep, it’s your query design.
I understand columns and rows.
How is tabular data different?
Rick
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?
r937
November 18, 2010, 5:59pm
5
different from query output? it isn’t
different from web page layouts? don’t go there
r937
November 18, 2010, 6:00pm
6
no, the resuts of the query would be inserted within TD tags by your web application language (asp, php, whatever)
r937:
no, the resuts of the query would be inserted within TD tags by your web application language (asp, php, whatever)
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
r937
November 18, 2010, 6:12pm
8
R_Schreiber:
… or in my case, easier?
any programming background? VB, perhaps? then use asp
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
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.