Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2006
    Posts
    2

    Report SQL/Data in Access

    I don't know much about access.



    I am trying to figure out where the data is coming from in an existing report.
    I can't seem to find the datasource, recordset information for the report.

    Does anyone know how to find that information in a report?

    Also, if this information comes from a module, how is the module linked to the report?

    Thanks.

  2. #2
    Join Date
    Jun 2006
    Posts
    7
    Open the report in design view and click "properties." It looks like a finger pointing to a piece of paper. Under the "Data" or "All" tab you'll see a field called "record source" or "data source." It could just be coming from a query.

    I don't know the answer to your macro question......

  3. #3
    Join Date
    Aug 2006
    Posts
    2
    I did what you said.

    The name of the record source is same as the name of my report.
    What does that tell me?

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

Similar Threads

  1. Sorting data in a report
    By rjsiler in forum Reports
    Replies: 1
    Last Post: 08-04-2008, 01:40 AM
  2. Access Programming and Access Data Page
    By frmdread67 in forum Programming
    Replies: 0
    Last Post: 03-19-2008, 03:11 PM
  3. Sumif in an Access report
    By tigers in forum Reports
    Replies: 0
    Last Post: 03-15-2007, 12:19 PM
  4. How to report data in fical year order
    By gemini2 in forum Reports
    Replies: 1
    Last Post: 05-27-2006, 06:26 AM
  5. Run report or sub form during data entry
    By wasim_sono in forum Programming
    Replies: 0
    Last Post: 03-09-2006, 05:40 AM

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