[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

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (15)

Recent Activity:

• New Members 5
• New Files 3

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___