[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/