Calculation in a query: is it possible?

Tibe · General User Joined: 23 Sep 2009 Posts: 7 Location: Italy

I created a database and then a query based on some parameters: as soon as I start the query the dialog box asks me for the parameter's value and the table with the results is shown.
Now I would have the sum of values that match the parameters on the query: I tried in more way without results: the only way I found is to do this is to create a new subquery, based on the previous one, and it works BUT the subquery asks me once again for the parameters.
The same thing happens presenting the results (query and subquery) in a form (query) and subform (subquery).
Is there a way to send the parameter's value from the query to a subquery? or, much better, obtain the sum directly from the first query?

Thanks a lot for your help!

T.

Tibe · General User Joined: 23 Sep 2009 Posts: 7 Location: Italy

Nobody can help me? pls.

T.

RPG · Posted: Tue Mar 23, 2010 3:31 pm Post subject:

Hello

Your question is several times anwered on this forum.

Learn seaching on internet. there you have found this forum you the limit in your results.
When you insert the next things in your search question then you can limit it to 21 results.

keywords : calculation query
Search for all terms : activate this radio button
author : Sliderule
Forum : OpenOffice.Org Base

then click on button search

Romke