Rich_Lovina
Registered User.
- Local time
- Tomorrow, 03:44
- Joined
- Feb 27, 2002
- Messages
- 225
Being away from my database I've forgotten a basic command (....getting too old??). Here's my sql"
SELECT GOVT_ACTOnly.FULLNAME, GOVT_ACTOnly.GazDate, GOVT_ACTOnly.GazNr, GOVT_ACTOnly.Name_ID, GOVDOUG.F25_ALLTAGS, GOVDOUG.EditedTag, GOVDOUG.F4_Deletes
FROM GOVT_ACTOnly INNER JOIN GOVDOUG ON GOVT_ACTOnly.Name_ID = GOVDOUG.Name_ID
WHERE (((GOVT_ACTOnly.FULLNAME) In (SELECT [FULLNAME] FROM [GOVT_ACTONLY] As Tmp GROUP BY [FULLNAME] HAVING COUNT(*)>1 And [FULLname] = [GOVT_ACTONLY].[FULLNAME])))
ORDER BY GOVT_ACTOnly.FULLNAME, GOVT_ACTOnly.GazDate;
This query won't let me manually change the checktags EditedTag OR F4_Deletes, yet a previous query I had will??
SELECT GOVT_ACTOnly.FULLNAME, GOVT_ACTOnly.GazDate, GOVT_ACTOnly.GazNr, GOVT_ACTOnly.Name_ID, GOVDOUG.F25_ALLTAGS, GOVDOUG.EditedTag, GOVDOUG.F4_Deletes
FROM GOVT_ACTOnly INNER JOIN GOVDOUG ON GOVT_ACTOnly.Name_ID = GOVDOUG.Name_ID
WHERE (((GOVT_ACTOnly.FULLNAME) In (SELECT [FULLNAME] FROM [GOVT_ACTONLY] As Tmp GROUP BY [FULLNAME] HAVING COUNT(*)>1 And [FULLname] = [GOVT_ACTONLY].[FULLNAME])))
ORDER BY GOVT_ACTOnly.FULLNAME, GOVT_ACTOnly.GazDate;
This query won't let me manually change the checktags EditedTag OR F4_Deletes, yet a previous query I had will??