Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2010
    Posts
    10

    Unanswered: Creating report for ONE record ONLY

    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 need a way to choose a specific record by filtering it with its ID for example, and make that into the report.

    Another thing is that when I've made a form to enter these records, can I make a report by clicking a button (which would ADD the records and open the report page)?

    Thanks.

  2. #2
    Join Date
    Oct 2009
    Posts
    340
    source the report on a query - and make sure that query returns just 1 record

  3. #3
    Join Date
    Jan 2010
    Posts
    10
    Thanks for your reply, which brings me to another question about the query.

    This has been eating my head for days.

    In that record I DO have an ID for each record, however by querying 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.

    How do I filter based on the criteria above and NOT by record ID?

    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •