Khalid-
I've tackled similar problems to this in my inventory applications. For example, I might sell a product by the "each" but buy the product by the "case". One way to deal with this is to have a product listed more than once in your database. The first version indicates individual products, and the second is a "case" that contains a multiple of the single product. You can also have a table refer to itself so that the "case" entry lists the "each" entry as the related product contained inside the case.
As for totaling on a form, if you're using a continuous form, you can add a control in the form footer that sums any numeric column. The control source looks like =Sum([Field Name]).
John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
(Paris, France)
On Mar 11, 2017, at 9:53 AM, Khalid Tanweer khalidtanweerburrah@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Hi John,
My user has a new demand for data entry on the form "New Cargo Collection Input" having subform "NewCargoCollectionInputsubform".
The situation is that the goods received from different clients have different Products in different Cartons, some times the Product is same, but packed in different cartons having different quantity and different weights. So there entry is made separately for each carton.
On the form there is no such control to mention that there are total how many cartons for this particular "ConsignmentNo" and Client. In different reports we get total cartons from different queries and checks, most of these are with consultation with you and your worthy suggestions and help.
Now the demand is that some times some clients do deliver some products in bulk packed in many cartons having normally same weight of each carton. Suppose a product "A" has 300 cartons or bags with same product and same weight of cartons or bags, my user needs instead of entering 300 cartons separately one by one, he may be able to make a single entry for these 300 cartons.
Now i am not getting the solution how to manage it.
Record Source of subform is:
SELECT CollectionVoucher.ConsignmentNo, [Consignment Number].ExportDocs, CollectionVoucher.Route, CollectionVoucher.ClientCIN, Clients.ClientName, CollectionVoucher.Destination, CollectionVoucher.DeliveryVr, CollectionVoucher.DeliveryVrDate, CollectionVoucher.CartonNo, CollectionVoucher.CartonSuffix, CollectionVoucher.TripNo, CollectionVoucher.UnitOfCarton, CollectionVoucher.ProductID, Products.ProductNameEnglish, Products.ProductNameRussian, Products.HSCode, CollectionVoucher.BrandName, CollectionVoucher.ProductQty, CollectionVoucher.UnitOfQty, CollectionVoucher.WeightOfCarton, CollectionVoucher.UnitOfGrossWeight, CollectionVoucher.[Net Weight], CollectionVoucher.UnitOfNetWeight, CollectionVoucher.UnitOfValue, CollectionVoucher.Rate, CollectionVoucher.Amount, CollectionVoucher.ID
FROM Products INNER JOIN ([Consignment Number] INNER JOIN (Clients INNER JOIN CollectionVoucher ON Clients.ClientCIN = CollectionVoucher.ClientCIN) ON [Consignment Number].ConsignmentNo = CollectionVoucher.ConsignmentNo) ON Products.ProductID = CollectionVoucher.ProductID
ORDER BY CollectionVoucher.CartonNo, CollectionVoucher.ProductID;
Help required please.
Regards,
Khalid
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar