Robin-
Is there any relationship between the two tables? That's what is keeping the
query from being updatable.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
<http://www.viescas.com/> http://www.viescas.com/
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
Sent: Friday, May 25, 2012 12:17 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Query not updateable
I have a query planned to provide a calculated field which is not updateable.
Is there any technique that I can use that will allow the calculation
to stay and new entries to be made?
SELECT tServiceProjects.ClubID, tServiceProjects.MonthID,
tServiceProjects.MonthDate, tServiceProjects.Description,
tServiceProjects.SumDonated, tServiceProjects.MembersInvolved,
tServiceProjects.TotalHours, tServiceProjects.ProjectID,
tServiceProjects.LastUpdated, [SumDonated]+([TotalHours]*[Rate]) AS
ServiceValue
FROM tServiceProjects, tServiceRate
WHERE
(((tServiceProjects.MonthDate)>IIf(Month(Date())>=7,Format(DateSerial(Year(Date(
)),7,1),"mm/dd/yyyy"),Format(DateSerial(Year(Date())-1,7,1),"mm/dd/yyyy"))));
Many thanks,
Robin Chapple
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar