Query filter problem

  • Thread starter Thread starter jodilees
  • Start date Start date
J

jodilees

Hi everyone

I have a database that I have created to track our work in progress.
The primary table has the records of all of the jobs. I have created
form to control this table and I have a subform that tracks invoicin
(more than one invoice per job).

I am trying to create a query that will allow me to have a summary o
the information in the main table and show a sum of invoicing that i
outstanding.

I have created the query and it is only working if there is an
invoicing against the job. For examble Job 1389 Contract value $100,00
- invoiced so far $10,000 will show a balance of $90,000. I want it t
show 0 in the invoicing if there is nothing against the job number wit
a total being the complete value of the Job. Eg example above would b
0 in invoicing column and balance $100,000. At present as soon as
put any fields with anything to do with invoicing it will not show th
entries in the main table that don't have any invoicing.

Sorry if this does not make sense, any feedback would be appreciated.

I am unsure of how to make the appropriate changes to make this work.

Kind Regards

Jod
 
Hello again everyone

I have just realised my subform has the same problem.

The Primary key for all of this is the Job number. I want the subfor
that sumarises all invoicing to return sums of all invoicing grouped b
job number. If there has not been an invoice issued for a Job numbe
then I would like the subform to return a value of '0'.

I am sure I need to put some type of if statement in the criteria o
the subform but I am not sure how do so this.

Kind Regards

Jod
 
Back
Top