artful at rogers.com
artful at rogers.com
Wed Feb 14 18:13:34 CST 2007
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