deanvilar
Registered User.
- Local time
- Today, 08:19
- Joined
- Mar 27, 2013
- Messages
- 63
Gurus,
how to query Select Distinct field + showing other fields?
e.g.:
how to query Select Distinct field + showing other fields?
e.g.:
Code:
SELECT DISTINCTROW assetMovementTable.assetNo, assetMovementTable.moveCode, assetMovementTable.compCode, assetMovementTable.compCodeDesc, assetMovementTable.assetDesc, assetMovementTable.equipType, assetMovementTable.equipManufacturer, assetMovementTable.equipModel, assetMovementTable.constYear, assetMovementTable.plateNo
FROM assetMovementTable
WHERE (assetMovementTable.equipType)=Forms!ASSET_PRINT_MODULE!txtEquipType And (assetMovementTable.toJobCode)<>"EXPORTED" And (assetMovementTable.toJobCode)<>"PSP" And (assetMovementTable.toJobCode)<>"FOR PSP" And (assetMovementTable.toJobCode)<>"DRILLING - TO" And (assetMovementTable.toJobCode)<>"DRILLING - FROM" And (assetMovementTable.toJobCode)<>"ATYRAU ERSAI" And (assetMovementTable.toJobCode)<>"ATYRAU SAIPEM" And (assetMovementTable.toJobCode)<>"BARGE E400"
ORDER BY assetMovementTable.assetNo;