Reports

[sdc1234]

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

[Dal Jeanis]

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.