Adam,
I would open a module and try to compile your code. If the issue is always with DateSerial(), I would search your code for another function with the same name.
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 28 May 2015 06:52:20 -0700
Subject: [MS_AccessPros] #Name? on report
I'm getting this on calculated fields in headers and footers, but not all calculated fields.
Header: I have a series of 12 monthly columns. The source for the first column is CompDate, a field on the report's source query. That field shows up correctly. The second column's source is =DateSerial(Year([CompDate]),Month([CompDate])-1,1); the third is =DateSerial(Year([CompDate]),Month([CompDate])-2,1); etc. #Name? shows up on the other 11 columns.
Footer: #Name? shows up in a field with the source ="Totals for " & [Product] where [Product] is a field in the report's source query, and in the detail (grouped by Product. Other Sum and Count calculated fields in the footer are fine.
This is happening on other reports with similar fields. These reports worked yesterday. Forms with the same sources and fields are working. I'm baffled. Any ideas?
Adam
I would open a module and try to compile your code. If the issue is always with DateSerial(), I would search your code for another function with the same name.
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 28 May 2015 06:52:20 -0700
Subject: [MS_AccessPros] #Name? on report
I'm getting this on calculated fields in headers and footers, but not all calculated fields.
Header: I have a series of 12 monthly columns. The source for the first column is CompDate, a field on the report's source query. That field shows up correctly. The second column's source is =DateSerial(Year([CompDate]),Month([CompDate])-1,1); the third is =DateSerial(Year([CompDate]),Month([CompDate])-2,1); etc. #Name? shows up on the other 11 columns.
Footer: #Name? shows up in a field with the source ="Totals for " & [Product] where [Product] is a field in the report's source query, and in the detail (grouped by Product. Other Sum and Count calculated fields in the footer are fine.
This is happening on other reports with similar fields. These reports worked yesterday. Forms with the same sources and fields are working. I'm baffled. Any ideas?
Adam
__._,_.___
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 (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar