Search results for query: *

No clue eh. I tried putting the rule on the total but no dice. Tried putting it on the field itself and having it do a sum and compare but again no dice. Its really a problem cause I got 2 other similiar situations now.

Hi People! I have a form that lists all Customer Orders by Order: Date Product Quantity [Button to open shipping form] Today UselessJunk 50 When you press the button on any line it opens a small form that you can put in the shipping amounts. You can enter as many shipments as...

Sorry guys once I wrote it out a solution came to me: I did one Dsum for one field - Dsum for the other field. Its a massive statement but it works. Anyone think of a more elegant solution?

Ok I have a table for receiving goods (ReceiveGoods) and it has: 1] RecQty - thats the amount ordered 2] RecRec - Thats the amount received I have an inventory table for all my products which has: 1] Onorder Problem: I want to do: RecQty-RecRec by product in my Receiving table and place the...

Thanx but unfortunately those wizards fail to take into consideration two major truths of buisness: 1] There are multiple POs under one invoice. 2] There are multiple invoices under one payment. Those are the problems that I can't solve. The rest is quite easy. I looked at the wizards but...

I'm having a real problem trying to make an inventory, purchase order, invoicing, payment system. So far I got form to enter products. I got a form to order those products from our only supplier. This tracks the onorder and onhand. It all comes apart when I do the purchase orders from our...

Hey its me I got a permanent handle. I work on every kind of IT project imaginable but I haven't touched access in literally years so its slow going. Thanks for your help it works. The funny part is I figured out after that I didn't even need to do it the way I wanted to. I was making the...