Thanks Paul,
That is correct. The table will only have one record.
Robin
At 17/04/2012 09:22 AM, you wrote:
>If you're asking if it will work, sure, probably. ;)
>
>I assume you only have one record in that table. What you will find
>is that if there are two records, it will double the number of
>records returned by this query. If there are 3 it will triple, and
>so on. An unjoined table will produce a Cartesean product.
>
>Paul
>
>
>--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple
><robinski@...> wrote:
> >
> >
> > 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
> >
>
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>
Tidak ada komentar:
Posting Komentar