inetserver asp db: 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.

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

Ray at home

[quoted text, click to view]

[quoted text, click to view]
<<
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.
[quoted text, click to view]

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...