jwcolby
jwcolby at colbyconsulting.com
Tue Apr 15 03:17:43 CDT 2008
qryHoursRemainingByMatterActionAndPerson is P FROM qryHoursRemainingByMatterActionAndPerson AS P and qsumHoursRemainingByMatterAction is A qsumHoursRemainingByMatterAction AS A Rocky Smolin at Beach Access Software 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 > > -- John W. Colby www.ColbyConsulting.com