Selecting data based on user input

[Svein Olav Steinmo]

Hi !

I have a table on my sql-server with date, value1, value2
How can I make a asp where the user can input date range, and the number of
values to return ? The returned numbers should then be the average for the
given number of rows.

If I have 1000 rows in the selected date range, and the user will return
only 10 numbers, then there will be one average for every 100 values.

I will use the result to present in a graph.

Svein Olav Steinmo

[Ray at]

Please don't take this the wrong way.

Have you created any asp pages before? Have you started working on this
one?

Ray at work

"Svein Olav Steinmo" <svein-olav@steinmo.no> wrote in message
news:mzfab.30948$Hb.472950@news4.e.nsc.no...

> Hi !
>
> I have a table on my sql-server with date, value1, value2
> How can I make a asp where the user can input date range, and the number

of

> values to return ? The returned numbers should then be the average for the
> given number of rows.
>
> If I have 1000 rows in the selected date range, and the user will return
> only 10 numbers, then there will be one average for every 100 values.
>
> I will use the result to present in a graph.
>
> Svein Olav Steinmo
>
>

[Bullschmidt]

As far as setting a date range based on posted fields:

strSQL = "SELECT * FROM MyTable WHERE (TheDateField >= #" &
Request.Form("MinDate") & "#) AND (TheDateField <= #" &
Request.Form("MaxDate") & "#)"

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Svein Olav Steinmo]

No, this is my first asp project. Sorry if the question was to basic, but Im
trying every way to get information. The way I have done the pages I already
have, is by using access and frontpage.

Svein Olav

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:OhjIoYefDHA.2748@TK2MSFTNGP11.phx.gbl...

> Please don't take this the wrong way.
>
> Have you created any asp pages before? Have you started working on this
> one?
>
> Ray at work
>
> "Svein Olav Steinmo" <svein-olav@steinmo.no> wrote in message
> news:mzfab.30948$Hb.472950@news4.e.nsc.no...

> > Hi !
> >
> > I have a table on my sql-server with date, value1, value2
> > How can I make a asp where the user can input date range, and the number

> of

> > values to return ? The returned numbers should then be the average for

the

> > given number of rows.
> >
> > If I have 1000 rows in the selected date range, and the user will return
> > only 10 numbers, then there will be one average for every 100 values.
> >
> > I will use the result to present in a graph.
> >
> > Svein Olav Steinmo
> >
> >

>
>