[MS_AccessPros] Unlinked table used in query

 

I have an Access front end on a server on the internet. Members read
the ASP pages which have been made by a code generator.

I experimented with this SQL because I needed the "Rate" in the
"tServiceRate" table to be variable without changing the code in the
query. I provide the administrator with an interface to the
"tServiceRate" table on line.

My tests have worked. Is this a documented technique that I can
reference somewhere? Are there any possible problems?

SELECT tServiceProjects.ProjectID, tServiceProjects.MonthID,
tReportMonth.ReportMonth, tReportMonth.MonthDate,
tServiceProjects.ClubID, tServiceProjects.Description,
tServiceProjects.SumDonated, tServiceProjects.MembersInvolved,
tServiceProjects.TotalHours, [TotalHours]*[Rate] AS ServiceValue,
[SumDonated]+[ServiceValue] AS Total
FROM tServiceRate, tServiceProjects INNER JOIN tReportMonth ON
tServiceProjects.MonthID = tReportMonth.ReportMonthID;

Many thanks,

Robin Chapple

__._,_.___

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

Messages in this topic (1)

Recent Activity:

• New Members 5
• New Files 1

Visit Your Group

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

.

__,_._,___