Report that displays number of records in queries rhia.perkins[ at ]gmail.com 29.09.2006 14:56:36 Hi there, I have a database I've set up that has a number of queries that filter the data by two (or more) checkboxes. I'd like to set up some kind of summary report that simply indicates how many records are in each of those queries. I feel like this should be simple, but I'm not coming up with any solutions that work... Any suggestions? Thanks!

Re: Report that displays number of records in queries fredg <fgutkind[ at ]example.invalid> 29.09.2006 17:20:53 On 29 Sep 2006 07:56:36 -0700, rhia.perkins[ at ]gmail.com wrote: [Quoted Text] > Hi there, > > I have a database I've set up that has a number of queries that filter > the data by two (or more) checkboxes. I'd like to set up some kind of > summary report that simply indicates how many records are in each of > those queries. I feel like this should be simple, but I'm not coming up > with any solutions that work... > > Any suggestions? > > Thanks! Since this is a Reports newsgroup, you can count how many records are returned in a query by using an unbound control in a report: =DCount("*","QueryName") -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail

Re: Report that displays number of records in queries "Rhia" <rhia.perkins[ at ]gmail.com> 29.09.2006 17:52:30 Thanks Fred! That works like a charm! I knew it had to be simple. fredg wrote: [Quoted Text] > On 29 Sep 2006 07:56:36 -0700, rhia.perkins[ at ]gmail.com wrote: > > > Hi there, > > > > I have a database I've set up that has a number of queries that filter > > the data by two (or more) checkboxes. I'd like to set up some kind of > > summary report that simply indicates how many records are in each of > > those queries. I feel like this should be simple, but I'm not coming up > > with any solutions that work... > > > > Any suggestions? > > > > Thanks! > > > Since this is a Reports newsgroup, you can count how many records are > returned in a query by using an unbound control in a report: > =DCount("*","QueryName") > -- > Fred > Please respond only to this newsgroup. > I do not reply to personal e-mail