Error

[NOORAIN ANSARI]

Dear All,

#Error : why and when comes, Please explain
and how can resolve it.

--
With Regards,
Noorain Ansari
http://noorainansari.com
http://excelvbaclinic.blogspot.com
http://accesssqclinic.blogspot.in/

 

[Rajan_Verma]

 

Noorain I think when we are doing any calculation in query and get any type of error in calculation with any record query will produce an error. So just check the data type before calculation

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

--
Forum Rules:
1) Use concise, accurate thread titles. Don't use Poor thread titles, like Please Help, Urgent, Need Help, Query Problem, Need Advice will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Acknowledge the responses you receive, good or bad.
4) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.
NOTE : Don't ever share your personal and confidential data . Forum owners and members are not responsible for any loss.
 
Group Email ID : acces...@googlegroups.com
Send Mail to Unsubscribe : access-sql+...@googlegroups.com
More Details about Group : http://groups.google.com/group/access-sql?hl=en

[Vikas Chouhan]

Calculated expressions show #Error when a form or report has no records

[noorain...@gmail.com]

Thanks Rajan and vikas to clear mY doubt regarding #ERROR

Sent from BlackBerry® on Airtel

---

From: Vikas Chouhan <vika...@gmail.com>

Sender: acces...@googlegroups.com

Date: Fri, 3 Aug 2012 08:47:24 +0530

To: <acces...@googlegroups.com>

ReplyTo: acces...@googlegroups.com

Subject: Re: $ Access-SQL $ Error

[Lalit_Mohan]

Hi Noorain,

If you want to remove such type of error then you can use IIF(CONDITION, TRUE, FALSE) condition on the field but if the data is huge then it may effect the performance.

Regards,

Lalit Mohan