Recent content by petelyons

Hi, there are about 15 significant fixes in SP1. Download at http://www.microsoft.com/sharepoint/downloads/sp1.asp

Thanks Mike, I will give this a shot too ;-) -Pete

Aivars, Many thanks! I will try this stuff out and see how I do. Thanks again! -Pete

Hi, I've got my queries designed just the way they need to be. Now I have to make 'em dynamic based on user selections from a critieria selection form. I have some simple examples books, like for filtering, but it's not enough information. I understand that I will have to embed my SQL into the...

I have been sooooo frustrated with this nuance of some of my subreports not displaying whenever there is zero (er, null) records returned from said subreports' Count query. My subreport design properties: Report: Data: a simple Count query -may sometimes return nothing (er, null) Hidden...

Thanks for the reply Joe. Unfortunately, and for whatever reason, the IsNull function didn't work for my situation; but I appreciate your pointing me in the right direction. I found that the IsError function does the trick: I first made a hidden textbox as follows: Data...

I recently had this same requirement for one of my reports. Here's what worked for me: 1. Create and save a Count query (assuming you know how). 2. Drag & drop this query into your 'master' report's footer area - then Access will create a subreport for you - so give it an intuitive name 'cuz...

Thanks for replying Jurgen. It's a simple borderless text box that shows the number of records found based on my Count query. All other text boxes based on other Count queries are showing the number just fine. Only the ones where the Count query returns no (er, null?) records found are showing...

Hi, I'm using a count query that in some cases will return zero; meaning no records found. In report preview, it displays #Error instead of zero. How can I make the report display a zero in this case? Hoping to save time with some canned VBA code if anyone has any. Thanks in advance! -Pete Lyons

The best way to accomplish this is to make a unique subreport for each of your queries. What I like to do is: create and save a new query file. With the report design view window open, drag & drop the query file into the report design window. Boom! You've now got a subreport in there. Repeat...

I had this same challenge before. The only way I could incorporate the output of multiple queries into a singel report was to make a unique subreport for each and every query. Although tedious, this is the only real way to do it.