[AccessD] Alias Table Name

D'oh!

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
Sent: Tuesday, April 15, 2008 6:46 AM
To: Access Developers discussion and problem solving
Subject: Re: [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
--
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/1377 - Release Date: 4/14/2008
9:26 AM