Ask Your Question

How to set up a calculation in a query with criterion

asked 2015-06-19 07:15:52 +0200

I have a base of Customers with purchases. I want to create a query that will sum the individual purchases for only that customer. My base has all the purchases from all the customers. I also would like to be able to limit it to just one date or date range. That way for example I could print out the sum for a specific customer but only for one week and not all his purchases from start to now.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-06-19 16:09:51 +0200

m.a.riosv gravatar image

I think you can find useful help in Base Tutorial (Mario Casanova) and TDF Documentation

edit flag offensive delete link more


And the simple answer is?

Sparksvonrou gravatar imageSparksvonrou ( 2015-06-26 06:00:52 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-06-19 07:15:52 +0200

Seen: 52 times

Last updated: Jun 19 '15