B
Barry
Good afternoon.I am a newbie to Access but very familiar with Excel.
Here is the setup:
3 tables linked to Oracle database
1 query using the 3 tables.
Relationships all to one record (Product_No)
I have created a query to give me all the info I need except one field
required a calculated field which works correctly when I run the query.The
problem I am having is that when I enter ">0" in the criteria under the
calculated field, I get no records to show and I know there are 314 records
before I enter the criteria and 182 are >0.(I counted) One of the records is
a sum.I need one line per item so the math will work
The calculated field is
'Needed:[QTY_ON_DEMAND]-[QTY_ON_ORDER]-[SumofQTY_ON_HAND]'
All records in the tables.Any help would be appreciated!
Here is the setup:
3 tables linked to Oracle database
1 query using the 3 tables.
Relationships all to one record (Product_No)
I have created a query to give me all the info I need except one field
required a calculated field which works correctly when I run the query.The
problem I am having is that when I enter ">0" in the criteria under the
calculated field, I get no records to show and I know there are 314 records
before I enter the criteria and 182 are >0.(I counted) One of the records is
a sum.I need one line per item so the math will work
The calculated field is
'Needed:[QTY_ON_DEMAND]-[QTY_ON_ORDER]-[SumofQTY_ON_HAND]'
All records in the tables.Any help would be appreciated!