[AccessD] Prompt for Proper Union Join Table

I was afraid of that.

Thanks,

Keith Williamson | Associate, Asst. Controller | kwilliamson at rtkl.com 

RTKL Associates Inc. | 901 South Bond St. | Baltimore, MD  21231

410.537.6098 Direct | 410.276.4232 Fax | www.rtkl.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, April 30, 2009 6:41 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Prompt for Proper Union Join Table

Not to my knowledge.  You could build it dynamically though (in code).

John W. Colby
www.ColbyConsulting.com


Keith Williamson wrote:
> Hey guys....below I have my Union Join Query:
> __________________________
> select "New Invs" as [Type], [WBS1] as [Project#], [Invoice] as
[Inv#],
> [FirstofTransDate] as [Date],  0 as [Balance], 0 as [Retainage],
> [Amount] as [NewInvAmt] from [qryARInvoices]
> 
> UNION select  "Orig Bals" as [Type], [Project#], [Invoice#] as [Inv#],
> [Date], [sumofbalance] as [Balance], [sumofretainage] as [Retainage],
0
> as [NewInvAmt] from [qryAR200812]
> 
> UNION select "New Invs" as [Type], [WBS1] as [Project#], [Invoice] as
> [Inv#], "" as [Date],  0 as [Balance], 0 as [Retainage], 0 as
> [NewInvAmt] from [qryARUnappliedPmts];
> _______________________
> 
> One of the issues I have is that I run this query for two different
> reports.  It is the same query, except that I change the [qryAR200812]
> to a different query [qryArcadisARBilling] for the second report.
> Additionally, two other of the sub-queries need to have this reference
> changed.  {essentially, this is a rollforward query of AR from either
> 12/31/08 or 05/31/07 to current....depending on the user}
> 
> My question is....is there a way to prompt for which reference I want
to
> use [qryAR200812] or [qryArcadisARBilling], and have this query
> reference the appropriate sub-queries?
> 
> Thanks,
> 
> Keith Williamson | Associate, Asst. Controller | kwilliamson at rtkl.com 
> 
> RTKL Associates Inc. | 901 South Bond St. | Baltimore, MD  21231
> 
> 410.537.6098 Direct | 410.276.4232 Fax | www.rtkl.com
> 
>
------------------------------------------------------------------------
--
> The information contained in this communication is confidential, may
be privileged and is intended for the exclusive use of the above named
addressee(s). If you are not the intended recipient(s), you are
expressly prohibited from copying, distributing, disseminating, or in
any other way using any of the information contained within this
communication. If you have received this communication in error, please
contact the sender by telephone at (410) 537-6000 or by response via
e-mail and permanently delete the original email and any copies.
> 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com