Results 1 to 2 of 2
  1. #1
    sdc1234 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2013
    Posts
    89

    Reports


    2 part question: I am trying to generate a report to send to the employee showing the # of vacation days and dates they have sent request in, I have got it to where It will generate only one date but the emp has multiple dates and I cannot seem to get the other dates, I generate a form in datasheet view and get all the dates requested, I want them to show up on my reports? how can I solve this problem

    2. I have multiple people with the came last names, how can I generate a report for a jane doe instead of john doe?

    Thanks for all the help

  2. #2
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    For most accurate answers, please look at your query in SQL view and post the exact SQL code here.

    1) To answer your first question, we'll also need to know how the tables are set up - especially the fields on the table that stores the requested dates they have sent in.

    2) For the second question, it sounds like you are selecting based on last name, rather than employee ID number. The answer is to do your joins and selects on the employee ID number, so the last names won't be confused.

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

Similar Threads

  1. 3 Reports into 1
    By kmims44 in forum Reports
    Replies: 2
    Last Post: 06-19-2012, 12:34 PM
  2. Convert Client Reports to Web Reports
    By need_help12 in forum Reports
    Replies: 0
    Last Post: 05-08-2012, 08:22 AM
  3. Get all reports
    By nkuebelbeck in forum Programming
    Replies: 13
    Last Post: 06-27-2011, 12:30 PM
  4. Reports w/ sub-reports very slow to open
    By vaikz in forum Reports
    Replies: 2
    Last Post: 02-27-2011, 08:41 AM
  5. Access Reports drop sub-reports
    By Kevin Ellis in forum Reports
    Replies: 0
    Last Post: 11-19-2010, 03:28 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