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![]()