Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2009
    Posts
    1

    query based report question - run report on one record

    So i have 3 tables in my DB, Estate, Room and Item



    Every estate has multiple rooms, each room has multiple items.

    I have made acceptable data entry forms for my employees using split forms/nested data sheets.

    I have record navigation button that switched the estate the user is viewing.

    I want a button to create a report for the estate at hand. This report will show the items in the estate, grouped by room.

    I have the report showing what i want, pulling data from the tables directly, but the problem is that it is reporting on all estates - not just the active one.

    How can i do this? I am trying to keep this as user friendly (least amount of typing/ideally just a single button) as possible.

    Thanks in advance.

  2. #2
    Join Date
    Jul 2008
    Location
    Alexandria, Egypt.
    Posts
    38
    Dear Skeyela,

    To do your requirement; the report must be through qurey not table.
    you can put a command buttom on your entry form to open the report.
    open the qurey in design view and write the following in criteria for Estate name or ID according to your design:

    [Forms]![your form name]![Estate]

    now when you press the buttom in your entry form the report will open according to the query.

    Please try and feedback
    If you need more help you can send me a sample of your data and I can send you what you need to do.

    Thanks

    Ahmed

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

Similar Threads

  1. Email a report of the current record.
    By jonudden in forum Reports
    Replies: 4
    Last Post: 08-21-2023, 07:37 AM
  2. Problem with Report Based on a Query
    By gmalaret in forum Reports
    Replies: 1
    Last Post: 11-25-2008, 08:38 AM
  3. Another email report question ...
    By valkyry in forum Reports
    Replies: 0
    Last Post: 05-23-2007, 11:42 PM
  4. Question on a report
    By Xena11 in forum Reports
    Replies: 2
    Last Post: 11-17-2006, 12:08 PM
  5. Probably a simple report question
    By gmurrie in forum Reports
    Replies: 1
    Last Post: 12-28-2005, 09:19 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