Hi,
I am in the process of developing a stock related database. I have imported the data as a linked table. (The bank end of the Excel table is a CSV File which comes from a further back end system).
From the linked table I am running query but have been looking to add manual formulas.
Having found the "Field" that I want to create I am using the following :
Free Stock: [Free Stk Qty]/[Min]
The problem is, on items where stock is 0 it details #Num!
Is there a way to set the field as above but detail the #Num! field data as a "0"?
Thanks for your help in advance.
Happy to provide more details/information if required.
I am in the process of developing a stock related database. I have imported the data as a linked table. (The bank end of the Excel table is a CSV File which comes from a further back end system).
From the linked table I am running query but have been looking to add manual formulas.
Having found the "Field" that I want to create I am using the following :
Free Stock: [Free Stk Qty]/[Min]
The problem is, on items where stock is 0 it details #Num!
Is there a way to set the field as above but detail the #Num! field data as a "0"?
Thanks for your help in advance.
Happy to provide more details/information if required.