Why is my select query asking for parameters 1

[Danyul]

Hi All

I have a query that should be a normal 'select' query but keeps askinig me for a parameter.

This is the query:

SELECT tbltransactionsbycatthismonth.key, (SELECT Sum([tbltransactionsbycatthismonth].[value]) AS Total
FROM [tbltransactionsbycatthismonth]
WHERE ((([tbltransactionsbycatthismonth].[key])<=[tbl_Alias].[key])) AS Total
FROM tbltransactionsbycatthismonth AS tbl_Alias;

This is the parameter its asking for:

tbltransactionsbycatthismonth.key


the field 'key' is the autonumber field within the table.

Any ideas ?

Dan

 

[nickjar2]

Hi,

Try this:

SELECT tbl_Alias.key, (SELECT Sum([tbltransactionsbycatthismonth].[value]) AS Total
FROM [tbltransactionsbycatthismonth]
WHERE ((([tbltransactionsbycatthismonth].[key])<=[tbl_Alias].[key])) AS Total
FROM tbltransactionsbycatthismonth AS tbl_Alias; Hope this is ok. If not, just let me know.

Nick (Everton Rool OK!)

 

[Danyul]

spot on - thanks Nick