What am I missing.... (1 Viewer)

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??
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 12:44
Joined
Feb 19, 2002
Messages
42,971
This query includes an aggregate function. That makes it not updatable.
 

Rich_Lovina

Registered User.
Local time
Tomorrow, 03:44
Joined
Feb 27, 2002
Messages
225
Thanks Pat, I had just worked that out, and as you correctly say elsewhere; must have the table design right and the relationships. That way I got it to do all I wanted with an ability to manually checked edited and duplicate records across multi-linked tables.
 

Users who are viewing this thread

Top Bottom