this query that a user created gives you a dialog box "like the edit parameters" box and you can put the month and year in yourself and it generates a report. Now I have one for searching my subforms last name field ALTER FUNCTION dbo.SearchLName(@Enter_SubjLastName nvarchar(100))RETURNS TABLEASRETURN ( SELECT dbo.Report.[Incident Report No], dbo.Subjects.SubjFirstName, dbo.Subjects.SubjLastName, dbo.Report.TypeOfIncidentFROM dbo.Report INNER JOIN dbo.Subjects ON dbo.Report.[Incident Report No] = dbo.Subjects.[Incident number]WHERE (dbo.Subjects.SubjLastName = @Enter_SubjLastName) )
This is a function and you enter in the last name and it generate a report for you, now from what I see hes doing the same thing but with Month and Year, does that make sense??