Reference a text box in a SUM formula?

[nvswd]

Hi everyone,

I have a database I have created to keep track of production units on the factory floor.

I am attempting to create a report, and not having much success getting the look that I want.

The data comes from the UNITDATA table, which has the following fields:
recordid - autonumber and primary key
date
employee
production type - which has 3 possible outcomes - PRODUCTIVE, NON-PRODUCTIVE, or REWORK
units

I created a simply query so I can specify a date range, and want a report with the dates down the page, and PRODUCTIVE, NON-PRODUCTIVE, and REWORK across the top.

I created a text box called PROD, which had the following formula IF([PRODUCTION TYPE]="PRODUCTIVE";[UNITS];0), so that it would list the values in "PRODUCTIVE" type only, and have a zero for the other values. I figure I could replicate this textbox for the other two types that exist.

Now, I need to sum the PROD text box...how can I do that? Then, I can just move the text boxes to where I want them on the report?

Thanks in advance.
nvswd
_________________
OpenOffice 3.2.1
Ubuntu Enthusiast

[Arineckaig]

Welcome to the forum.

FWIW I find it easier to use Calc to produce reports of this type from data held in a Base registered database table. Open a new Calc spreadsheet, press f4 to open the link to the registered database.

It is then a relatively simple matter to filter the beamer (upper window) table to the required date range. Copy the resulting records and paste in the spreadsheet. You can then perform the required display and calculations more easily in Calc - even data pilots. One of the great strengths of OOo Base is that it works well with Calc and Writer.
_________________
When this issue has been resolved, it helps other users of the forum if you add the word [Solved] to the Subject line of your 1st post (edit button top right).
OOo 3.4.1 and MySQL on MS Windows XP and Ubuntu

[nvswd]

[nvswd]

Just one thought on that, I would like the report to be 'dynamic' - in that I don't want to have to recreate the calc spreadsheet each time new data is added. Is there some documentation on how base and calc work together that I can reference?
_________________
OpenOffice 3.2.1
Ubuntu Enthusiast

[Arineckaig]