|
WingMan -> Count(aaa) Giving Error... (12/7/2005 15:49:36)
|
Hey,
This seems to be an easy one, but I have yet to figure it out... more the fact that I am fairly new to FP, SQL and Access.
Okay, so basically I have a page that has a drop-down box that passes along a parameter to 3 seperate queries on the page. The parameter is named D1 (as in drop-down 1 I guess). The parameter is a number (1, 2, 3 or 6). Note, that each query works fine when the parameter is hard coded in (i.e. instead of D1 I put 1).
The first query works fine, and is:
SELECT arena_name
FROM arenas
WHERE (((arenas.arena_id)=::D1::));
The second query is the one the fails, and is:
SELECT [won]+[lost]+[tied] AS GP, Count(sched.win) AS Won, (SELECT Count(sched.win) FROM sched
WHERE (((sched.win)=2) AND ((sched.arena)=::D1::));) AS Lost, (SELECT Count(sched.win) FROM sched
WHERE (((sched.win)=3) AND ((sched.arena)=::D1::));) AS Tied
FROM sched
WHERE (((sched.win)=1) AND ((sched.arena)=::D1::));
The third query works fine, and is:
SELECT sched.date, sched.o_team, sched.o_score, sched.vs, sched.m_score, sched.m_team
FROM sched
WHERE (((sched.arena)=::D1::));
Any direction would be greatly appreciated!
Thanks,
WM
|
|
|
|
