Query is not updating table

[Guest]

I have a form that has a query named "qry_MemberFirmsView" but this query is
not updating the table "tbl_MemberFirmsView". The value is in the query but
not in the table. The value came off the form into the query.

How do I get the query to update the table?

Here is the query sql statement:
SELECT tbl_MFirmMain.MemberName, tbl_CTAMain.CTAName, tbl_CTAMain.IDNumber,
tbl_MFirmMain.MemberFID
FROM tbl_CTAMain INNER JOIN tbl_MFirmMain ON tbl_CTAMain.CTAName =
tbl_MFirmMain.CTAName
ORDER BY tbl_MFirmMain.MemberName, tbl_CTAMain.CTAName;

I have other forms that reads this same table and I need to get the table
"tbl_MemberFirmsView" updated.

Thanks.

Donna

 

[Michel Walsh]

Hi,


.... using an Update query? A SELECT query, like what you have, retrieve the
data, it does not modify the data in the table in any way.



As example, to update the UnitPrice of ItemID:



UPDATE ListOfPrices INNER JOIN NewPrices ON
ListOfPrices.ItemID=NewPrices.ItemID
SET ListOfPrices.UnitPrice = NewPrices.NewUnitPrice




Sure, you can also use the graphical query designer.



Hoping it may help,
Vanderghast, Access MVP