vb.net and access database issue

Question

I got this error:

your query does not include the specified expression as part of an aggregate function

When i tried to execute this:

SELECT DISTINCT invoice_details.item,
SUM((invoice_details.cartoons * products.punits) + invoice_details.units) as units,
SUM(invoice_details.total) as total
FROM invoice_details, products, invoices
WHERE invoices.invoice_id = invoice_details.invoice_id
and products.pname = invoice_details.item
and format(invoices.create_date, "d/mm/yyyy") = DATE()

Gireesh kumar · Accepted Answer · 2017-11-10 06:54:49Z

1

Sum is an Aggregate Function so all the Other fields which are been called in the query must be used in Group by clause. this may resolve the issue.

answered Nov 10, 2017 at 6:54

Gireesh kumar

581 silver badge12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

vb.net and access database issue

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related