Re: [MS_AccessPros] #Error in a report on a calculated field

 

I would try without the query name

=[DYofAge]

When you reply to emails in this group, please include the previous emails.

Duane Hookom

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of jovaughn@rochester.rr.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, September 28, 2016 11:18 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] #Error in a report on a calculated field

 

My report shows a #Error in a field for a calculated field

=[AQry_M_Fecundity]![DYofAge]        this is in the REPORTS control property field

In the Query I have

DYofAge: DateDiff("d",[M_DOB],Now())  

__._,_.___

---

Posted by: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___