Question access - Update with nested select query

[the_penfool]

Hi guys, will be brief cuz im stressed.this is access DB btw
whats wrong with this update statement
select statement work well on its own.
design to update any records in accounts table with no date of issues after 2007 in mailing table. tells me only 1 record can be returned, if I use exist I get all records.THANKS

UPDATE [Tbl Mailing Details] SET Lapsed = 1
WHERE (SELECT [Tbl Quote Information].[Mailing ID]
FROM [Tbl Quote Information] INNER JOIN [Tbl Mailing Details] ON [Tbl Quote Information].[Mailing ID] = [Tbl Mailing Details].[Mailing ID]
GROUP BY [Tbl Quote Information].[Mailing ID]
HAVING (((Max([Tbl Quote Information].[Date of Issue]))<#9/1/2007#)));

[the_penfool]

may have fixed it by adding IN....


UPDATE [Tbl Mailing Details] SET Lapsed = 1
WHERE [Mailing ID] IN (SELECT [Tbl Quote Information].[Mailing ID]
FROM [Tbl Quote Information] INNER JOIN [Tbl Mailing Details] ON [Tbl Quote Information].[Mailing ID] = [Tbl Mailing Details].[Mailing ID]
GROUP BY [Tbl Quote Information].[Mailing ID]
HAVING (((Max([Tbl Quote Information].[Date of Issue]))<#9/1/2007#)));

[Ashish Singhal]

You need to put some condition in where clause like as you are fetching mailid from other tables then u can match mailid and put the condition like WHERE mailid in (SELECT....

[shanonfields]

Need a vehicle list that’s clean, simple and won’t cost you (or your client) hundreds of dollars to buy and maintain? Our ‘Full Size’ model is robust and highly functional, but doesn’t have the excessive number of fields that many users don’t want or need.