Sub Report Problem (1 Viewer)

A

access2010

Registered User.

Local time

Today, 12:11

Joined

Dec 26, 2009

Messages

1,022

• Jun 8, 2018

• #1

Hello.

Could I be advised as to what I have done wrong as my Sub Report is not producing the results that we want.

Thank you,
Fabiola

 

Attachments

• Sub Report Credit Card Totals.mdb

  460 KB · Views: 55

pbaldy

Wino Moderator

Staff member

Local time

Today, 12:11

Joined

Aug 30, 2003

Messages

36,127

• Jun 8, 2018

• #2

Care to share what it is you do want?

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 12:11

Joined

Aug 30, 2003

Messages

36,127

• Jun 8, 2018

• #3

If I had to guess, the query should be:

SELECT VendorPayables.[Vendor#], Vendors.[Vendor Name], Sum(VendorPayables.InvoiceTotal) AS SumOfInvoiceTotal, Sum(VendorPayables.InvoicePersonal) AS SumOfInvoicePersonal, Sum(VendorPayables.InvoiceAuto) AS SumOfInvoiceAuto
FROM VendorPayables INNER JOIN Vendors ON VendorPayables.[Vendor#] = Vendors.[Vendor#]
GROUP BY VendorPayables.[Vendor#], Vendors.[Vendor Name];

 

A

access2010

Registered User.

Local time

Today, 12:11

Joined

Dec 26, 2009

Messages

1,022

• Jun 8, 2018

• #4

Thank you for reading my mind.

Your query has fixed our problem.

T H A N K S,
Fabiola

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 12:11

Joined

Aug 30, 2003

Messages

36,127

• Jun 8, 2018

• #5

No problem Fabiola. That was what I suggested in post 6 here:

https://www.access-programmers.co.uk/forums/showthread.php?t=300008

You just have more fields now.