M
Marc T
Hi All,
I have a query to return documentation info (doc number, revision etc). What
I'd like to do is have a query that only returns the latest revisions of the
documents. The field that gives this is a numerical field - REV_NO that is a
revision counter, but I'm completely stumped as a relative newbie to access!
Here's my current SQL query:
SELECT I.DOC_CLASS, I.DOC_NO, I.DOC_REV, T.TITLE, I.DOC_REV_TEXT, I.REV_NO,
I.DOC_SHEET, I.DT_PLANNED_FINISH, I.DT_PLANNED_START, I.DT_RELEASED
FROM User_Selection, IFSAPP_DOC_ISSUE As I INNER JOIN IFSAPP_DOC_TITLE As T
ON I.DOC_NO = T.DOC_NO
WHERE (((Mid([I.DOC_NO],1,5))=[User_Selection].[Proj_ID]))
ORDER BY I.DOC_NO;
Any advice would be much appreciated!
Marc
I have a query to return documentation info (doc number, revision etc). What
I'd like to do is have a query that only returns the latest revisions of the
documents. The field that gives this is a numerical field - REV_NO that is a
revision counter, but I'm completely stumped as a relative newbie to access!
Here's my current SQL query:
SELECT I.DOC_CLASS, I.DOC_NO, I.DOC_REV, T.TITLE, I.DOC_REV_TEXT, I.REV_NO,
I.DOC_SHEET, I.DT_PLANNED_FINISH, I.DT_PLANNED_START, I.DT_RELEASED
FROM User_Selection, IFSAPP_DOC_ISSUE As I INNER JOIN IFSAPP_DOC_TITLE As T
ON I.DOC_NO = T.DOC_NO
WHERE (((Mid([I.DOC_NO],1,5))=[User_Selection].[Proj_ID]))
ORDER BY I.DOC_NO;
Any advice would be much appreciated!
Marc