ASP results

I am very new to ASP. What I want to do is, Show results by each month
from data sent from a input page. The results page now shows all data
from the past year in a table. Is there a way to only show the current
month and past month but maybe archive the other months? Maybe
something I can add to the input form page? I know this may not be
enough information but maybe someone will understand. Thanks in advance.

Re: ASP results

Where is this data being stored? In a database? What kind? How are you
getting the data now?

Ray at home

"tedssupply" wrote in message
news:1121720998.454971.214760@g44g2000cwa.googlegroups.com.. .
>I am very new to ASP. What I want to do is, Show results by each month
> from data sent from a input page. The results page now shows all data
> from the past year in a table. Is there a way to only show the current
> month and past month but maybe archive the other months? Maybe
> something I can add to the input form page? I know this may not be
> enough information but maybe someone will understand. Thanks in advance.
>

Re: ASP results

tedssupply wrote:
<<
I am very new to ASP. What I want to do is, Show results by each month
from data sent from a input page. The results page now shows all data
from the past year in a table. Is there a way to only show the current
month and past month but maybe archive the other months? Maybe something
I can add to the input form page? I know this may not be
enough information but maybe someone will understand. Thanks in advance.
>>

Example setting a date range to be the current and previous months:

strSQL = "SELECT * FROM MyTable WHERE (TheDateField >= #" &
DateSerial(Year(Date()), Month(Date()) + 1, 0) & "#) AND (TheDateField
<= #" & DateSerial(Year(Date()), Month(Date()) - 1, 1) & "#)"

Example 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 Designer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex http://www.developersdex.com ***