Make one row for every invoice and it’s payment (1 Viewer)

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 16:30
Joined
May 7, 2009
Messages
19,169
see query3 in design view.
 

Attachments

  • Mobarak - 23-6-2021.zip
    2 MB · Views: 121

mobarak ahmed

Member
Local time
Today, 10:30
Joined
May 28, 2021
Messages
95
Dear arnelgp , Why query 2 just show invoices which have payment but doesn't show the other invoices
 

Attachments

  • Mobarak - 28-6-2021 - Copy.zip
    2.3 MB · Views: 91

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 16:30
Joined
May 7, 2009
Messages
19,169
i change the query to Left Join
 

Attachments

  • Mobarak - 28-6-2021 - Copy.zip
    2.2 MB · Views: 105

mobarak ahmed

Member
Local time
Today, 10:30
Joined
May 28, 2021
Messages
95
I can't make sub total text box for Balance , invoice value, and payment in footer of " ReportsCustomerProject" form
 

Attachments

  • Mobarak - 14-7-2021.zip
    2.4 MB · Views: 102

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 16:30
Joined
May 7, 2009
Messages
19,169
see ReportsCustomerProject form.
 

Attachments

  • Mobarak - 14-7-2021.zip
    1.7 MB · Views: 111

mobarak ahmed

Member
Local time
Today, 10:30
Joined
May 28, 2021
Messages
95
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
 

Attachments

  • Invoices.pdf
    2.7 MB · Views: 153
  • Mobarak - 14-7-2021 - Copy.zip
    1.8 MB · Views: 115

mobarak ahmed

Member
Local time
Today, 10:30
Joined
May 28, 2021
Messages
95
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 !
 

Attachments

  • Mobarak - 4-8-2021.zip
    2.1 MB · Views: 101

Gasman

Enthusiastic Amateur
Local time
Today, 08:30
Joined
Sep 21, 2011
Messages
14,050
Your sum control should be in the group footer and it's running sum property should be over group.
 

Gasman

Enthusiastic Amateur
Local time
Today, 08:30
Joined
Sep 21, 2011
Messages
14,050
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

Member
Local time
Today, 10:30
Joined
May 28, 2021
Messages
95
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

Member
Local time
Today, 09:30
Joined
Jun 10, 2020
Messages
119
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 ...
 

Attachments

  • Mobarak - 10-8-2021.zip
    1.8 MB · Views: 111

mobarak ahmed

Member
Local time
Today, 10:30
Joined
May 28, 2021
Messages
95
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 :)
 

mobarak ahmed

Member
Local time
Today, 10:30
Joined
May 28, 2021
Messages
95
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 :D
 

Attachments

  • 3.jpg
    3.jpg
    477.5 KB · Views: 107
  • 2.jpg
    2.jpg
    480.9 KB · Views: 105
  • 1.jpg
    1.jpg
    493.5 KB · Views: 106

Users who are viewing this thread

Top Bottom