Results 1 to 2 of 2
  1. #1
    GeorgePR is offline Novice
    Windows 10 Office 365
    Join Date
    Sep 2022
    Posts
    1

    Post How to print a specific record from 2 tables data

    Hi



    I have one table for Studentes and other table for activities.

    Table 1(Student)
    stId
    stName
    stLasName
    stPhone
    stEmail

    Table 2 (Activity)
    actId autoNumber
    actStudentId
    actName
    actDate

    I need to create a report with the above fields. Looking into different web sites I found how to create the report, but it's printing all my records and I need to print a specific record.
    Please help

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    11,337
    Your report should be based on a query that does the filtering (I presume you've used a table). If you cannot, you would have to filter the report.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Replies: 4
    Last Post: 11-03-2020, 10:32 AM
  2. Replies: 2
    Last Post: 08-25-2017, 08:16 AM
  3. Replies: 14
    Last Post: 01-10-2012, 03:12 PM
  4. Print a specific record
    By NISMOJim in forum Forms
    Replies: 5
    Last Post: 01-28-2011, 04:32 PM
  5. Print a specific record report from a form
    By cynthiacorley in forum Reports
    Replies: 27
    Last Post: 02-08-2010, 06:34 AM

Tags for this Thread

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