[AccessD] Textr box on a Report

Dlookup works.  You could also write a function that returns the value.
Dlookup is not known for its speed but it is just there, always available
(so seductive). 


John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----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 2:50 PM
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/