ACCESS FEED: Re: [MS_AccessPros] #Name? on report

Kamis, 28 Mei 2015

Re: [MS_AccessPros] #Name? on report

Adam-

Maybe corruption in your database? Sometimes reports "lose" the available field name list. You can reset that by opening the report in Design view, changing the Record Source to something else (doesn't matter what), then changing it back.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On May 28, 2015, at 3:52 PM, runuphillracing@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

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: John Viescas <johnv@msn.com>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)