Making a macro to produce a report based on fields

[sammy]

Greets.



In my database I have a section which stores records (specifically, items that need to be repaired). I need you guys to help me make a macro which will produce a report for fields older then two weeks.

I have pasted the sql code to make the report manually hopefully you can catch my jist, if not please do not hesitiate to say.

SELECT Problem.[Date Submitted], Problem.[Date Completed], Problem.[Fault Log Number]
FROM Problem
WHERE (((Problem.[Date Completed])>[Date Submitted]+14));

Thank you a trillion

[weekend00]

you have the query already, and you can create report using this query as data source. why do you need a macro?