Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2011
    Posts
    7

    Unanswered: REports Questions

    I have a question about access reports, first off i would like to say that i'm very new using this application and I will need your help .
    My question is the following:
    is it possible to filter reports by employee name?
    A brief description, I have a database with 300+ employees on, and the main purpose of this database is to input customers complaints against employees if any is reported.
    is it possible to create a form that has the specific report name, let's say employee customer complaints report and select only one employee from that list and print only the reports or complaints of that employee alone?

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    Yes the wizard will do part of the work for you use the wizard and them look at the code

    I would use the where part of the open report only show the emp u want to look at
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Select Allen Browne has a short tutorial that covers the subject here:

    Microsoft Access tips: Print the record in the form

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    Join Date
    Dec 2011
    Posts
    7
    thanks for the help, you guys are great.

  5. #5
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    That we could help!

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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