Calculation field not passing through to report

[jbaccess]

I have the following code in an extended query that feeds into a form. The calculated fields show up in the query and on the form, but when I go to create an invoice report... nothing shows up. I have the same problem for my Tare Weight and Net Sale fields ... I'm sure once I figure one out, I'll have the solution to the other. Here's the code:

Net Sale: [Inventory Transactions]![Weight (lbs)]-[Container Types.CTWeight]*[Inventory Transactions.Bid]

In the report I have the control source set to: Net Sale

I've also tried pasting the formula directly into the report - but that only created errors.

Thanks in advance

 

[boblarson]

If you have nulls (no value) in any of the fields, it will give you a null.

Try changing to this (I'm assuming that you have the Inventory Transactions table and ContainerTypes table in the query and you need to change the table/field referencing for a few things I showed in red also):

Net Sale: Nz([Inventory Transactions].[Weight (lbs)],0)-Nz([Container Types].[CTWeight],0)*Nz([Inventory Transactions].[Bid],0)

 

[jbaccess]

When I do the above, it shows up in the Inventory Transactions Extended just fine, but it does not provide any new information to the Inventory Transactions table. Thus, I'm gussing that when my report is looking at the table, it still sees a null.

 

[jbaccess]

If you have nulls (no value) in any of the fields, it will give you a null.

Bob, thanks for the above, but I still am not getting a recorded value placed into the [Inventory Transactions] table, thus I get a null value and nothing is shown on the report.

How can I get the calculated values from the [Inventory Transactions Extended] to post into the [Inventory Transaction] table. I'm certain that once that step is completed, my report will show "much better"

Thanks again for your paitience.

Jim

 

[boblarson]

If you have nulls (no value) in any of the fields, it will give you a null.

Bob, thanks for the above, but I still am not getting a recorded value placed into the [Inventory Transactions] table, thus I get a null value and nothing is shown on the report.

How can I get the calculated values from the [Inventory Transactions Extended] to post into the [Inventory Transaction] table. I'm certain that once that step is completed, my report will show "much better"

Thanks again for your paitience.

Jim

You don't put it into your table. You would be using that in a query that is bound to the report (not a table bound to the report) and just DISPLAYING the value. You don't normally store calculated values in the table. You calculate them at runtime with a query.