Search results

Tried it in table->format... Where should it be executed?

Created report, and would like to display total net weight and total gross weight. As you can see in th attached files each case id has one or more record of net weight, so total gross weight will be Sum([netweight]+20) It is working for first case id but gross weight data is wrong in the...

Please find the attached screen shot of the error

I would like to join autonumber field and a text and save it to another field. For example Autonumber test_field 1 w1 2 w2 3 w3 44 w44 tried "W"+""[autonumber] in test_field format, but its not working...

Thank you for the reply, im new to this system and coding. Can you please explain how to resolve it.

How to update value from unbound text box to table. tried the following DoCmd.RunSQL "Update in SET remquantity_in =" & Me!Text35 & "where out.productid_out = in.productid_in AND out.ponumber_out = in.ponumber_in'" but it shows RUN TIME ERROR 3144 Syntax error in UPDATE statement Please help...

I want to create a sequential number for jobs "WI"&&&, it increments. How to update this in each record?

Hi, I am creating a warehouse inventory and I want to update each job with a unique job number. For example: Each job has different line of products coming IN/OUT. product1 ... 50 quantity ... suppliername product2 ... 25 quantity ... suppliername and so on So when I search using job number it...

Thank you for the suggestion. When I save the product out form system should decrement/reduce the record from warehouseIN table/transaction table For eg: ProductOUT (10 quantity PO:123 Invoice:dfg) the following record in warehouseIN must change to (40 quantity PO:123 invoice:dfg) actual...

Product is taken based on PONumber and Invoice number not by FIFO/LIFO. One single product may have different PO and invoice numbers, so when a product is ordered (taken out) corresponding product with same PO and invoice number must be reduced from the inventory

these three values are fetched from one single table i.e; product registry

Forget to mention one thing, there are different records of same product in the inventory. So when quantity out is entered calculate the total available in the inventort and decrement the quantity out value. Do I need to create new table for warehouse Inventory or warehouse In table is enough...

Hi, Im new to access. Trying to build a inventory database, following are the tables and its fields product productid productname supplier uoq weight warehouseIN productid productname supplier uoq quantity PONumber invoicenumber caseid warehouseOUT productid productname supplier uoq quantity...