Hi, running Access 2007.
I have a report which lists and totals job orders.
When opened in Print Preview all is correct, but when opened in Report View everything is there EXCEPT any calculated fields - they are blank.
If you go on to print, or print to PDF the totals are there.
I need to be able to open first in report view as there are buttons visible in this view that are used to make modifications before printing.
One strange thing - this happens on all our office computers except one. On my own persoanl laptop (same machine used to create the DB originally) everything works fine. Is it possibly a security setting difference betweeen machines?
The data for the calculated fields comes from a Dlookup to a query
=Nz(DLookUp("[SumOfCabTotal]","qryOrdersTotal","ProjectID = [ProjectID]"),0)+Nz(DLookUp("[SumOfAddItemSub]","qryOrdersAdditionalTotal","ProjectID = [ProjectID]"),0)
Thanks
I have a report which lists and totals job orders.
When opened in Print Preview all is correct, but when opened in Report View everything is there EXCEPT any calculated fields - they are blank.
If you go on to print, or print to PDF the totals are there.
I need to be able to open first in report view as there are buttons visible in this view that are used to make modifications before printing.
One strange thing - this happens on all our office computers except one. On my own persoanl laptop (same machine used to create the DB originally) everything works fine. Is it possibly a security setting difference betweeen machines?
The data for the calculated fields comes from a Dlookup to a query
=Nz(DLookUp("[SumOfCabTotal]","qryOrdersTotal","ProjectID = [ProjectID]"),0)+Nz(DLookUp("[SumOfAddItemSub]","qryOrdersAdditionalTotal","ProjectID = [ProjectID]"),0)
Thanks
