Need smart person

[BringBackZezel]

obviously, I'm asking in the wrong place, but I'm trying to edit a website that was built in Frontpage 2003 with an access database.

Before we talk about how shitting Frontpage and Access are, realize one thing: I don't give a shit. I'm editing someone elses work...and don't feel the need to fuck around with building form scratch with SQL and PHP.

The database is a very simple repository for inventory information that will only add maybe 40 records a year.

Currently, the user is downloading the access db and running some reports locally.

I'm wondering if there's a way to get those reports to run (or build new reports to run) directly from the website.

[Blues Fan in TX]

Get a Mac.

[BringBackZezel]

I'm disappointed it took this long to get a wiseass remark.

[ElviswasaBluesFan]

Originally posted by BringBackZezel@Aug 26 2005, 12:04 PM
I'm disappointed it took this long to get a wiseass remark.

Quoted post

Yeah, but you had to know you'd get a smartass reply before you got one that actually helped right?

[BringBackZezel]

Originally posted by ElviswasaBluesFan+Aug 26 2005, 12:06 PM-->

QUOTE(ElviswasaBluesFan @ Aug 26 2005, 12:06 PM)

[Moon Man]

Have you tried Google? Or Posner? Is Buccigross doing a web Q&A today? Reasonable options, all.

Moon

[Turd Ferguson]

According to google, these are all smart people -

[Donuts_For_Koharski]

Originally posted by Moon Man@Aug 26 2005, 11:19 AM
Have you tried Google? Or Posner? Is Buccigross doing a web Q&A today? Reasonable options, all.

Moon

Quoted post

[Iowa_Card]

.ASP

[madyaks]

PGrote would be the one to help you with this

[Moon Man]

Originally posted by madyaks@Aug 26 2005, 12:00 PM
PGrote would be the one to help you with this

Quoted post

His power is out.

Moon

[sherwood koho]

yeah you will have to use a programming language like asp. you can construct sql statements to get records from the access database.

[BringBackZezel]

Originally posted by sherwood koho@Aug 26 2005, 01:47 PM
yeah you will have to use a programming language like asp. you can construct sql statements to get records from the access database.

Quoted post

The ASP pages are built for input and output, but only a simple report....which just lists records.

They want me to include other things like running totals and % calculations based on the data.

[Blues Fan in TX]

Try this

Not sure if that's going to help or not, but a) it's worth a shot and b) I already suggested getting a Mac

[sherwood koho]

Well once you have opened the recordset, you can assign field records to variables, do math on the variables etc. and then write the output to the screen. It's not as pure and simple to do what you are asking. Crystal Reports may accomplish some of it...