Results 1 to 4 of 4
  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,922
    The OpenReport function will accept a WhereCondition argument.

  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,922
    This link might help explain what I said.

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