it's an excel world
Board Regular
- Joined
- Sep 17, 2008
- Messages
- 126
Hello all,
I am struggling to understand the approach I need to take in order to accomplish the following. I have a Orders table and a Transactions table. I am trying to identify the value in the TransactionID field on the Transactions table where the value in the Partnumber field on the Orders table and Partnumber field on the Transactions table are equal AND the Date/time field on the Transactions table is greater than the date/time field on Orders table. However, there can be many instances of a greater date/time stamp, and I am only interested in the first occurrence.
In Excel I would use the Index Match functionality to accomplish this but having a very difficult time understanding Access. A co-worker mentioned possibly running a subquery to first identify the records with like partnumbers, then an additional query to identify the first occurrence.
Any assistance would be greatly appreciated!
I am struggling to understand the approach I need to take in order to accomplish the following. I have a Orders table and a Transactions table. I am trying to identify the value in the TransactionID field on the Transactions table where the value in the Partnumber field on the Orders table and Partnumber field on the Transactions table are equal AND the Date/time field on the Transactions table is greater than the date/time field on Orders table. However, there can be many instances of a greater date/time stamp, and I am only interested in the first occurrence.
In Excel I would use the Index Match functionality to accomplish this but having a very difficult time understanding Access. A co-worker mentioned possibly running a subquery to first identify the records with like partnumbers, then an additional query to identify the first occurrence.
Any assistance would be greatly appreciated!