Grouping Query by Date Problem (1 Viewer)

access2010 · Jun 14, 2018

Hello.

We would like to use the attached Query for a footer in a Access 2003 report.

I can not find a way to have the following date grouping in our query.

Between #8/1/2015# And #7/31/2016#

Your assistance would be appreciated.

Nicole

pbaldy · Jun 14, 2018

Change Expression to Where on the date field and see if that gives the desired result.

access2010 · Jun 14, 2018

Thank you for your suggestion which we have tried,
Between #8/1/2015# And #7/31/2016#
Where #8/1/2015#" And #7/31/2016#
"Where VendorInvoiceDate" #8/1/2015# And #7/31/2016#

but still receive the error message below

You tried to execute a query that does not include the specified expression “VendorInvoiceDate” as part of an aggregate function

Pat Hartman · Jun 14, 2018

This is how the query should look

SELECT VendorPayables.InvoiceDistribution, Sum(VendorPayables.InvoiceTotal) AS SumOfInvoiceTotal
FROM VendorPayables
WHERE (((VendorPayables.VendorInvoiceDate) Between #8/1/2015# And #7/31/2016#))
GROUP BY VendorPayables.InvoiceDistribution;

Looking at it in QBE view, where it says "expression" should be replaced with "where" and that will fix the problem.

access2010 · Jun 14, 2018

T H A N K S

Thank you for helping us with this Sub Report Query which now works

Nicole

pbaldy · Jun 14, 2018

No problem Nicole.

Grouping Query by Date Problem (1 Viewer)

access2010

Registered User.

Attachments

pbaldy

Wino Moderator

access2010

Registered User.

Pat Hartman

Super Moderator

access2010

Registered User.

pbaldy

Wino Moderator

Similar threads

Users who are viewing this thread