Make one row for every invoice and it’s payment

[arnelgp]

see query3 in design view.

 

[mobarak ahmed]

Dear arnelgp , Why query 2 just show invoices which have payment but doesn't show the other invoices

 

[arnelgp]

i change the query to Left Join

 

[mobarak ahmed]

I can't make sub total text box for Balance , invoice value, and payment in footer of " ReportsCustomerProject" form

 

[arnelgp]

see ReportsCustomerProject form.

 

[mobarak ahmed]

Awesome

 

[mobarak ahmed]

Why I Can't Make a Report Fitting All "ReportsCustomerProject" Form Data which come From "QryReportSubCustomerProject" Query
i know it's too much data side by side but i need all of it like i was working in Excel

 

[mobarak ahmed]

Kindly Reminder

 

[mobarak ahmed]

hi , i have a report named " ReportCustomerProject " it should show all projects in one page sort by
1- project type
2- customer name
3- project name
and it should show the sup total of every project but now the total text box shows total of all projects under every project

any help or advices !

 

[Gasman]

Your sum control should be in the group footer and it's running sum property should be over group.

 

[mobarak ahmed]

Your sum control should be in the group footer and it's running sum property should be over group.

sorry but i need help to apply what you say , the database is attached

 

[Gasman]

sorry but i need help to apply what you say , the database is attached

Oh no it isn't
Plus it is too recent if it was, as I only have 2007, but someone else can take a peek.

 

[mobarak ahmed]

hi , i have a report named " ReportCustomerProject " it should show all projects in one page sort by
1- project type
2- customer name
3- project name
and it should show the sup total of every project but now the total text box shows total of all projects under every project

any help or advices !

Mr arnelgp is always helpful in this issue

 

[CarlettoFed]

In the attachment you can see the example where I took the liberty of modifying the Data Source of the subform which is now given by Query3 without the need to set all those conditions as in the QryReportSubCustomerProject. Furthermore, I would like to point out that the database structure is not correct as it has data redundancy, lack of management of the fundamental properties of the fields (Required and Indexed type), etc ...

 

[mobarak ahmed]

In the attachment you can see the example where I took the liberty of modifying the Data Source of the subform which is now given by Query3 without the need to set all those conditions as in the QryReportSubCustomerProject. Furthermore, I would like to point out that the database structure is not correct as it has data redundancy, lack of management of the fundamental properties of the fields (Required and Indexed type), etc ...

I am brand new access user but i am trying to do my best by see tutorials and ask friends here and there
so I know their is a lot of problems in this database but I need badly to finish it in order to use it in my work place to help me make many reports in short time

 

[CarlettoFed]

Yes, but the attachment satisfied your request.

 

[mobarak ahmed]

Yes, but the attachment satisfied your request.

unfortunately No .. you have made changes in form that I don't need and the "projects report" button is not working
in the report
1- the page became smaller and didn't take all report in one page A2 size will be perfect
2-i want the report to show up all projects in one report
3- the total row shown three times to every project which one time is enough
4- i wondered how you create project name footer