Hi Nurse Nancy,
If i delete this: [Prime]*[# Prime Spots] AS Total
Then I can update the form
Then do the calculation in the form instead of the query. You're already
selecting the two fields, [Prime] and [# Prime Spots] in the SELECT
statement, so these fields are available to the form. Just set the Control
Source for a text box as follows:
=[Prime]*[# Prime Spots]
Make sure to give this text box a different name from either of the fields
involved. So, perhaps name it: txtTotal
Suggestion:
Get rid of any special characters (including spaces, # signs, etc.) and
reserved words in things that you assign a name to within Access, such as
fields, tables, queries, forms, reports, macros, modules, controls on forms &
reports, and variables in VBA code. Access MVP Allen Browne offers a free
utility that you can use to scan your tables & queries for this issue:
Database Issue Checker Utility
http://allenbrowne.com/AppIssueChecker.html
Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
Nurse Nancy said:
scratch that, i am still in need of help
As soon as I added the Calculation the form becomes recordset not updateable
Here's the SQL now
SELECT WBQ.STATION, WBQ.[Buy Status], WBQ.Keep, WBQ.MISC,
WBQ.[source #], WBQ.M, WBQ.T, WBQ.W, WBQ.TH, WBQ.F,
WBQ.[Total Calls], WBQ.CPC, WBQ.[Primary Day Part],
WBQ.[Rotator Day Part], WBQ.[Other Day Part], WBQ.Comments,
WBQ.[Format ID], WBQ.[Station Rep], WBQ.[Market ID], WBQ.RS.[Opt In],
WBQ.[Rep ID], WBQ.[Contact ID], WBQ.[First Name_Group], WBQ.[Last
Name_Group], WBQ.[Full Name_Group], WBQ.ROS, M.[State ID],
WBQ.Prime, WBQ.[# Prime Spots], WBQ.[Prime Spots Posted],
WBQ.[# Rot Spots], WBQ.[Rot Spots Posted], WBQ.[# Other Spots],
WBQ.[Other Spots Posted], WBQ.[Total Calls], [Prime]*[# Prime Spots] AS Total
FROM [Weekly Buy Query] AS WBQ INNER JOIN [MARKETS TABLE] AS M
ON WBQ.[Market ID] = M.[Market ID];
If i delete this: [Prime]*[# Prime Spots] AS Total
Then I can update the form
please help me
