[AccessD] Alias Table Name

Well there is your answer then

qryHoursRemainingByMatterActionAndPerson AS P
qsumHoursRemainingByMatterAction AS A

GK

On 4/14/08, Rocky Smolin at Beach Access Software
<rockysmolin at bchacc.com> wrote:
> SELECT P.MatterActionID, P.PersonID, P.HoursRemaining, A.TotalHoursRemaining
> FROM qryHoursRemainingByMatterActionAndPerson AS P INNER JOIN
> qsumHoursRemainingByMatterAction AS A ON P.MatterActionID = A.MatterActionID
> WHERE (((P.PersonID)=getpid()) AND ((P.HoursRemaining)>0) AND
> (([Forms]![frmTM]![chkHoursRemaining])<>False)) OR (((P.PersonID)=getpid())
> AND ((A.TotalHoursRemaining)<=0) AND
> (([Forms]![frmTM]![chkHoursRemaining])<>False)) OR (((P.PersonID)=getpid())
> AND (([Forms]![frmTM]![chkHoursRemaining])=False));
>
> Two field lists aliased as A and P.
>
> Rocky
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
> Sent: Monday, April 14, 2008 5:01 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Alias Table Name
>
> Rocky, can you show us the SQL?
>
> Susan H.
>
>
> > Not in this case.  No source.
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> No virus found in this incoming message.
> Checked by AVG.
> Version: 7.5.519 / Virus Database: 269.22.13/1376 - Release Date: 4/13/2008
> 1:45 PM
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Gary Kjos
garykjos at gmail.com