S
Saj
Hi
Anyone that can help me with the below:
I have a order form with a orderline subform. This has a field for user to
enter quantity for items being ordered. On entering this quantity I want it
to look up a value which will have to be in a query, and if it is greater
than the result in the query it should give a msgbox (saying e.g not enough
stock reduce quantity).
How can I do this?
I created a query to show me the total items in stock for stock items.
I have also created a query to show me total items orderd by all customers
for items.
What I want is to combine the two queries to give me remaining stock for the
item being entered, and to look at what quantity was entered to make sure it
is less than or equal to what is in stock.
Tried doing this but got duplicate rows in the table and wrong sums
calculated.
Can anyone help me with this?
Thanks in advance.
Anyone that can help me with the below:
I have a order form with a orderline subform. This has a field for user to
enter quantity for items being ordered. On entering this quantity I want it
to look up a value which will have to be in a query, and if it is greater
than the result in the query it should give a msgbox (saying e.g not enough
stock reduce quantity).
How can I do this?
I created a query to show me the total items in stock for stock items.
I have also created a query to show me total items orderd by all customers
for items.
What I want is to combine the two queries to give me remaining stock for the
item being entered, and to look at what quantity was entered to make sure it
is less than or equal to what is in stock.
Tried doing this but got duplicate rows in the table and wrong sums
calculated.
Can anyone help me with this?
Thanks in advance.