[AccessD] Textr box on a Report

Hey Arthur,

Thats what I did...built the final query...and referenced it via DLookup on 
the report.

Thanks Again,

Mark A. Matte


>From: artful at rogers.com
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Textr box on a Report
>Date: Wed, 14 Feb 2007 16:13:34 -0800 (PST)
>
>In all probability it's just a DLookup or DSum but even if the query is 
>complex, it will all resolve down to some such variant. And then you could 
>plonk the whole statement into a saved query and just call that instead.
>
>
>Arthur Fuller
>Technical Writer, Data Modeler, SQL Sensei
>Artful Databases Organization
>www.artfulsoftware.com
>
>
>
>
>----- Original Message ----
>From: Jim Lawrence <accessd at shaw.ca>
>To: Access Developers discussion and problem solving 
><accessd at databaseadvisors.com>
>Sent: Wednesday, February 14, 2007 5:41:48 PM
>Subject: Re: [AccessD] Textr box on a Report
>
>
>Mark:
>
>Have you considered using a cross-tab query to populate the report?
>
>HTH
>Jim
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
>Sent: Wednesday, February 14, 2007 11:50 AM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] Textr box on a Report
>
>Hello All,
>
>In A2K I have a report that needs a seperate count of somehting in the
>DB...non related to the recordsource of the report.  It is a single
>number...but there is a lengthy SQL statement that gets this number...any
>suggestions on the best approach?  I was thinking about creating a
>query...then using dlookup.  Does this sound like a good approach?
>
>Thanks,
>
>Mark A. Matte
>
>_________________________________________________________________
>Dont miss your chance to WIN 10 hours of private jet travel from Microsoft
>Office Live http://clk.atdmt.com/MRT/go/mcrssaub0540002499mrt/direct/01/
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Invite your Hotmail contacts to join your friends list with Windows Live 
Spaces 
http://clk.atdmt.com/MSN/go/msnnkwsp0070000001msn/direct/01/?href=http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us