From tableA, need a query to get to something like TableB.
TableA:
TableB:
In Access, i tried multiple queries to get it done. I like one query that does it. It may use less resources.
TableA:
Quote:
ID, ProdID, BatchID,ProdType,inpdate, inptime, CarrierID, CarrierName, delivered, comments, fieldn,fieldn+1,location |
TableB:
Quote:
ID, prodID, BatchID, MAx(inpdate+inptime), CarrierName, delivered, location where delivered is "yes" and location is "loc1" |
In Access, i tried multiple queries to get it done. I like one query that does it. It may use less resources.
query help
0 commentaires:
Enregistrer un commentaire