getting variable value

[alh1002]

I am making a query up to a certain date, I want to then have that End date as a result in the query (note everything is aggregate functions, so all the other things are summing, multiplying to get single values from table) I just want the query to also return the date value as well as my aggregrate functions

here is last part of what I am dealing

FROM tblPerformance
WHERE tblPerformance.ladder_date<=[Enter End Date]

 

[alvechurchdata]

If you are working with SQL, just add [TT][Enter End Date][/TT] to the list of fields. If you need it to be called something else, say [TT][Enter End Date] AS [Final Date][/TT].

If yo are working in the Query Designer, add a column [TT][Final Date]:[Enter End Date][/TT].

Geoff Franklin

http://www.alvechurchdata.co.uk