Report not showing all records

[duchessofireland]

I'm trying to produce a report showing all records (jobs) whether the job has
a completed date or not, so we can see what is outstanding. I evidently
don't know how to do that, because it's only giving me the information on the
report for the records that have every part filled in. If I have any piece
of information (not required) missing from the record, it wont show it on the
report. I know you probably need more information...Please just ask me. Am
newbie (that's why I'm here). I can give you more detailed information, if
you tell me what you need. Thanks in advance!

 

[Jerry Whittle]

We all had to learn at one time.

First off is the report based on just one table or a query? Open the report
in design view and bring up the Properties for the entire report. Go to the
Data tab and look at the Record Source. Is it the name of a table, query, or
something like "SELECT ....."?

If it's a table, then you probably have a filter listed in the next row
down. Remove the filter and see it that works. If not reopen in design view
and see if the filter reappeared.

If either a query on SELECT statement, then you have a join between 2 or
more tables. This join probably says INNER JOIN and that would prevent
records from getting into the report unless the joined tables both had a
matching record. You could try changing the INNER JOIN to a LEFT JOIN or
RIGHT JOIN. To do this you just change the wording in the SELECT statement OR
open up the query in design view. Then double click on the line between the
two tables until a dialog box shows up. Then try option 2 or 3. You can run
the query without opening up the report for testing.

 

[duchessofireland]

Woo hoooooo!!! That worked! Thank you sooooo much. Do you have patience
for one more question? lol Hope so.

I have employee(s) assigned to these jobs. I want a report that will show
information for ONE job but in the employee(s) field - show ALL of their
names that have been assigned. I can't get it that way...I either get rows
showing all duplicate job information, but with different employees.....or I
get one row of job information and only the very first person assigned to the
job. I think it's because access sees this as separate records for each
employee, but it's the same job. Any ideas? Thank you!

 

[Jerry Whittle]

Do you have a table for Jobs and another for Employees? If so you need a
third table. I'm assuming that a Job can have many Employees and that an
Employee could be on multiple Jobs. That's a classic many-to-many
relationship which databases don't handle well. Databases like one-to-many
relationships between tables.

Therefore you need to interject a third table between Jobs and Employees.
Let's call it EmpJobs. This table would have at the very minimum two fields:
something like EmployeeID and JobID. These two fields would be the primary
key fields in the other two tables. Here you would assign a job to an
employee. That way you could write a query which would say what employees
were on a particular job and also what jobs an employee was assigned. You
would need to link the three tables to get this information.

 

[duchessofireland]

Yes I do have a table for jobs and one for employees. I also already have
the 3rd table as "assignments". The "assignments" table contains the
primary keys from employees and jobs. That part I think I have right.

My problem is....

I have my form created to fill in the pertinent job information...I have a
subform that is a combo box where I choose employees. When I choose an
employee, it adds them and adds another blank line below to choose another
employee or not. They seem to be individual records inside of the main
record. When I try to print a report about a job, it only shows me the first
person chosen. Does that make sense? I don't know if I'm saying it right.
Thanks for all your help.