|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 17th, 2006, 08:15 PM
posted to microsoft.public.access.reports
|
|||
|
|||
#Error on Count(*)
Report contains field where the control source is =Count(*). When there are
no records, #Error is returned. Is there a way to have "no records found" appear instead of this "#error"? Thx. 
|
|
#2
May 17th, 2006, 09:01 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
#Error on Count(*)
Hi.
There may be a better way, but here's how I got this to work: Add a new TextBox with the Control Source set to =Count(*). Name it "txtCount2" (or similar), and make it invisible. Now change the Control Source of your original TextBox to: =IIf(IsError([txtCount2]),"",Count(*)) -Michael "christyh" wrote: Report contains field where the control source is =Count(*). When there are no records, #Error is returned. Is there a way to have "no records found" appear instead of this "#error"? Thx.
|
|
#3
May 17th, 2006, 09:05 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
#Error on Count(*)
Thank you for your input. I also found that this seems to work:
=IIf([HasData],Count([FIELDName]),"No records found") "Michael H" wrote: Hi. There may be a better way, but here's how I got this to work: Add a new TextBox with the Control Source set to =Count(*). Name it "txtCount2" (or similar), and make it invisible. Now change the Control Source of your original TextBox to: =IIf(IsError([txtCount2]),"",Count(*)) -Michael "christyh" wrote: Report contains field where the control source is =Count(*). When there are no records, #Error is returned. Is there a way to have "no records found" appear instead of this "#error"? Thx.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| type conversion erron in update querry | Leonard Hart | Running & Setting Up Queries | 1 | June 3rd, 2004 01:11 AM |
Linear Mode
