L
Lori
I've got two queries set up to help distribute invoice costs. In most cases
the cost is billed at 100% but about 15% of the line items need to be
distributed. I have one query that breaks down the invoices by our cost code
for the 100% lines. I have another query called Distriubted invoices which is
linked to a form that allows the user to distriubte the line item based on
the # of hours billed during a given month. This part works perfectly,
however, there are several items that are "disbursed" that are not part of
the 100% group. The cost codes where there are both 100% lines and
distributed works perfectly but the ones where there are no 100% line items
don't show up at all.
Is there a way I can get all of the items to show up in a query? I can't
join the two existing queries because it will eliminate the items not in the
distributed group.
HELP!
I've tried to
the cost is billed at 100% but about 15% of the line items need to be
distributed. I have one query that breaks down the invoices by our cost code
for the 100% lines. I have another query called Distriubted invoices which is
linked to a form that allows the user to distriubte the line item based on
the # of hours billed during a given month. This part works perfectly,
however, there are several items that are "disbursed" that are not part of
the 100% group. The cost codes where there are both 100% lines and
distributed works perfectly but the ones where there are no 100% line items
don't show up at all.
Is there a way I can get all of the items to show up in a query? I can't
join the two existing queries because it will eliminate the items not in the
distributed group.
HELP!
I've tried to