Hey Link do you know this?

[schase]

Access 2000

to start from the beginning.

database "gvfforce"
Multiple tables

Two affected in Query are tblPilots and tblScores

I have a Query in Access that does a left join. It sums together all score information - groups it by a month.


I have an asp page that shows scores (pulled by the Query). I want the default score page to show the current months scores only. And later links where someone could click say November 2001 and see that particuliar months.

Is there a link manipulation I can do in asp to accomplish this? like

http://www.domain.com/db/scores.asp?Date="November

2001"

Or will the query not allow that? Or will I need to do separate Queries for every month?

Thank you in Advance.

 

[Cheech]

Hey,

If what you want is what I think you want, then just build the link from variables.

DDmenu code
value = Nov 01
value = Dec 01
etc

strRedirect = "

http://www.domain.com/db/scores.asp?Date="

strRedirect = strRedirect & DDmenu

or along those lines, you get the jist of it? Live long and make your kids suffer..

 

[schase]

I see what your talking about - implimenting it I may be lost.

Do I need to do a Dim variable below the recordset like
<%
Dim DDmenu
value = November 2001
value = December 2001
%>
<%
Dim strRedirect
strRedirect = &quot;

http://www.domain.com/db/scores.asp?Date=&quot;;

%>

Then the link somewhere along the lines of
<a href=&quot;<% strRedirect & DDmenu = &quot;November 2001&quot; %>November 2001</a>


Then in the link do the strRedirect

 

[Cheech]

Make a Jump menu on scores.asp and have the user select the date there.

then when building the value of each option

menuOpt = &quot;

http://www.domain.com/db/scores.asp?Date=

November 2001&quot;

etc

then do a check at the top of scores.asp to look for Date in the querystring if there select that months details if not select current month.

If its still not clear repost and I will have a go at knocking up some code for ya Live long and make your kids suffer..

 

[schase]

Ok, I see what you are saying, will it work pulling info from an access query or do i need to create another query?