Results 1 to 4 of 4

Creating report for one record only with complex filtering.

  1. #1
    kenanselo is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2010
    Posts
    5

    Creating report for one record only with complex filtering.

    Hi everyone,

    I need help.

    I have a table with many records (and many fields too) and I need to create a report for ONE record only, right now whenever I add a field its adding ALL records pertaining to that field.

    I already made the input form (which i think is basic but its working at least.)

    I need a way to choose a specific record by filtering it from TWO fields which produce a unique record.

    By querying the TWO fields I will get a unique result. For example: i have Name and Date. There can be more than one name per date and vice versa but ONE name will have only ONE unique date.

    So I can have name: Germany and France to Jan 15th 2010, and I can have Germany to Jan 15th and Jan 20th, but by choosing both Germany and Jan 15th I get only ONE possible record as Germany can't have more than one Jan 15th.



    How do I filter based on the criteria above and NOT by the record ID, so that I can create a report by choosing Name and then it filters to the Dates of that particular Name, then I would choose the Date (which would be maximum of two but usually one) and then create a report for the corresponding record, which will have to be unique.

    Then I want to be able to click a button on my form AFTER i have inputted the fields and be able to view this particular record that I just entered as a form.

    Thanks.

    Thanks.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,577
    The OpenReport function will accept a WhereCondition argument.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  3. #3
    kenanselo is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2010
    Posts
    5
    hehe sorry but i'm not very familiar with anything you said since my knowledge isn't that great with databases in general.

    please explain further thanks.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,577
    This link might help explain what I said.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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

Similar Threads

  1. Complex Query/Queries for a Report
    By Rawb in forum Queries
    Replies: 3
    Last Post: 02-04-2010, 06:44 AM
  2. Replies: 3
    Last Post: 01-14-2010, 07:32 AM
  3. Filtering in a report
    By SIM_2009 in forum Reports
    Replies: 1
    Last Post: 10-06-2009, 03:22 AM
  4. Report Filtering
    By HM1 in forum Reports
    Replies: 2
    Last Post: 07-06-2009, 05:06 AM
  5. Filtering my report
    By ldarley in forum Reports
    Replies: 1
    Last Post: 09-05-2008, 08:14 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
  •  
Tech Forums: Microsoft Office Forums