Frustrated! Field to join 2 queries

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

I have 2 queries:
1) Schedule
2) Employee Assigned

They both have a ticket number that is the same.
They both have an activity date that is the same, although
the field names are different. The data is coming from
several tables. I got it down to 2 queries, both
accurate. Now I'm trying to join the two so I can see the
schedule along with the employee assigned. In some cases
the employee field will be null.

When I try to join them on either of these fields, I get
invalid data.

Any help is greatly appreciated. I've been looking at
this too long!!

Thanks,
Mary
 
Hello Mary,

The only thing I can think of is to make sure the queries are joined with an
inner join, that is, if you look at the join properties it should only show
records where both fields are the same. This is the default when you create
a query, but I have seen cases where I got an outer join.

Ragnar
 
Back
Top