Hello All, I was wondering if th

[DarkOne72]

Hello All,

I was wondering if this would be possible to have in a database.
What I have is a quantity field for inventory and a reorder level; what I want to happen is automatically email me if any given item is equal to or less than the reorder level.
The trick, I would guess, is to make it where it is always checking the table and the quantity levels.
Is this possible, if so how could I accomplish this?

Thanks.

 

[Andrzejek]

You may want to investigate triggers in Access

Have fun.

---- Andy

 

[DarkOne72]

Thank you for the reply,

I found out where you can do it with data macros for a table but the atcual quantity in stock is an if statement in a query.
I can't seem to get it to work porperly with queries.