Results 1 to 2 of 2
  1. #1
    sammy is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2010
    Posts
    1

    Making a macro to produce a report based on fields

    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

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    you have the query already, and you can create report using this query as data source. why do you need a macro?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 10-16-2009, 07:54 AM
  2. Making the like operator work for fields
    By olidav911 in forum Queries
    Replies: 2
    Last Post: 06-06-2009, 01:57 AM
  3. Making report from 2 queries
    By QueeN in forum Reports
    Replies: 1
    Last Post: 04-20-2009, 01:36 PM
  4. Making fields dissapear
    By rev_ollie in forum Access
    Replies: 0
    Last Post: 09-11-2008, 03:56 PM
  5. making specific fields non-editable
    By narayanis in forum Forms
    Replies: 3
    Last Post: 08-06-2008, 12:22 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums