Queries :: Passthrough Query To Remember Password

I have the following query that has been developed for me but it constantly asks for the password. Is there a way of storing/automating this for reporting?

Code:
SELECT dbo.tbl_staff.Name, dbo.tbl_function.funct, dbo.tbl_dates.CalendarDate, dbo.tbl_activity.Details
FROM dbo.tbl_staff INNER JOIN dbo.tbl_function ON dbo.tbl_staff.Funct = dbo.tbl_function.id
CROSS JOIN dbo.tbl_dates
LEFT JOIN dbo.tbl_activity ON dbo.tbl_activity.idstaff = dbo.tbl_staff.id AND dbo.tbl_activity.startdate = dbo.tbl_dates.CalendarDate

[Code] .....