[AccessD] Textr box on a Report

Thanks Jim,

I'm not sure how I would use a crosstab to come up with the single number 
I'm looking for?...and then reference from the text box on the report?

I am curious about your approach.

Thanks,

Mark


>From: Jim Lawrence <accessd at shaw.ca>
>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 14:41:48 -0800
>
>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

_________________________________________________________________
Laugh, share and connect with Windows Live Messenger 
http://clk.atdmt.com/MSN/go/msnnkwme0020000001msn/direct/01/?href=http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=hmtagline