Report only pulling a couple of records.

[sohendalski]

I have a report "Billing Period" and it runs off of 5 small queries
"InvoiceQuery", "AdminQuery", "ProjManQuery", "InspectionQuery" and
"ExpensesQuery".

The InvoiceQuery has the information such as Client, Invoice #, Job #,
Description, Beg and Ending Dates, Reimbursed Expenses and Total
Invoice Amount.

The AdminQuery, ProjManQuery, InspectionQuery and ExpensesQuery only
gather the sum of the "Billed Amount" for that particular
classification that is entered into the main table.

When I run the queries separate they work perfectly fine. However
when I run a report combining all of this information, it will only
pull up two of the entered invoices. There seems to be no ryhme or
reason to it, they are the first and fourth Invoices entered. They
have different Job #'s, amounts and everything. The only similarities
is the client name, however it does not pull all of the invoices for
that client just the same two invoices.

I would appreciate any help someone may have

[storrboy]

On Feb 16, 10:02 am, "[e-mail]" <[e-mail]>
wrote:

I have a report "Billing Period" and it runs off of 5 small queries
"InvoiceQuery", "AdminQuery", "ProjManQuery", "InspectionQuery" and
"ExpensesQuery".

The InvoiceQuery has the information such as Client, Invoice #, Job #,
Description, Beg and Ending Dates, Reimbursed Expenses and Total
Invoice Amount.

The AdminQuery, ProjManQuery, InspectionQuery and ExpensesQuery only
gather the sum of the "Billed Amount" for that particular
classification that is entered into the main table.

When I run the queries separate they work perfectly fine. However
when I run a report combining all of this information, it will only
pull up two of the entered invoices. There seems to be no ryhme or
reason to it, they are the first and fourth Invoices entered. They
have different Job #'s, amounts and everything. The only similarities
is the client name, however it does not pull all of the invoices for
that client just the same two invoices.

I would appreciate any help someone may have

Have you tried to make a single query out of these and base the report
on that?
I have to wonder if the report is making joins or groupings that
you're not expecting.
Making one query and reviewing the results might help you sort it out.

[sohendalski]

Ok, I tried that and it still didn't work, however I think I figured
out what the error is. I went through and tried to compare all the
invoices to figure out the differences.

I think it has to do with the fact that some of the invoices (records)
don't have data for each of the queries. Some of them there are only
hours for "Inspection" some with only "Project Managment", etc.

Is there a way I can fix it where if there is not data for every query
it will still pull the invoice and the data for the others?

[salad]

so*********@gmail.com wrote:

I have a report "Billing Period" and it runs off of 5 small queries
"InvoiceQuery", "AdminQuery", "ProjManQuery", "InspectionQuery" and
"ExpensesQuery".

The InvoiceQuery has the information such as Client, Invoice #, Job #,
Description, Beg and Ending Dates, Reimbursed Expenses and Total
Invoice Amount.

The AdminQuery, ProjManQuery, InspectionQuery and ExpensesQuery only
gather the sum of the "Billed Amount" for that particular
classification that is entered into the main table.

When I run the queries separate they work perfectly fine. However
when I run a report combining all of this information, it will only
pull up two of the entered invoices. There seems to be no ryhme or
reason to it, they are the first and fourth Invoices entered. They
have different Job #'s, amounts and everything. The only similarities
is the client name, however it does not pull all of the invoices for
that client just the same two invoices.

I would appreciate any help someone may have

If you create a query in the builder and add 2 tables together you can
link them together. Usually it is a key (main table) to the foreign key
in the many table. You'll see a line between the two tables that
creates the link. If you dbl-Click on the link line it will pull up a
window to modifiy the link. You should set your link to All records in
the main and matching records in the child. That way you'll get the
detail if detail exists but you will always get the parent data.

[sohendalski]

Thank you both so much. I have been trying with this thing for two
days now!!!