D/ALL
'THANKS TO THIS FORUM', In the last 10 days have started from scratch and managed to make tables, forms, queries and report for crew and items sold.
I am stuck in my last lap i.e:
1. In one query "Q_SALES_QTY" able to get various staff buying various items as sum of quantity sold in the expression [ROB1] for each item.
2. I am trying to use an update query joining the item_table with this "Q_SALES_QTY"; and wanting to update the [ROB] field in the "item_table" by putting the following in the update to [Q_SALES_QTY].[ROB1]
Why am I unable to do?? Some reading up suggested I cant use the query which has a calculated field like the one I am having [ROB1].
So pls help me with above problem or suggest other ways to deduct from the original quantity onboard, as this will be the last hurdle before I put the project to full use.
brgds/captgnvr
'THANKS TO THIS FORUM', In the last 10 days have started from scratch and managed to make tables, forms, queries and report for crew and items sold.
I am stuck in my last lap i.e:
1. In one query "Q_SALES_QTY" able to get various staff buying various items as sum of quantity sold in the expression [ROB1] for each item.
2. I am trying to use an update query joining the item_table with this "Q_SALES_QTY"; and wanting to update the [ROB] field in the "item_table" by putting the following in the update to [Q_SALES_QTY].[ROB1]
Why am I unable to do?? Some reading up suggested I cant use the query which has a calculated field like the one I am having [ROB1].
So pls help me with above problem or suggest other ways to deduct from the original quantity onboard, as this will be the last hurdle before I put the project to full use.
brgds/captgnvr