New price is not updated in the report (1 Viewer)

[hfsitumo2001]

Hello, I created report with access 2016 3 years ago, I put the unit price in the Inventory item, not in the Price table. So any time I updated price, the report should show with the new price, but I found it no changed in the report it is till with the old price. Anyone can help me why it was not working for the new price?. My computer was change with the windows 11 and the cpu also was changed with 64 bit. Was it that caused the problem?

Thank you for any helps.

Frank

 

[Mike Krailo]

What do you mean "put the unit price in the inventory item"? If you copied it there, of course it won't change. Your price table should always show the current unit price and your invoices should always show the price at the time of the sale (copied).

 

[Gasman]

Was it that caused the problem?

Highly unlikely. Are you sure you are referencing the correct field?
Upload a sanitized version of your DB with enough to show the issue.