Text box expression

[tweetyksc]

This is one of those things that I do on the fly and usually have no problems but sometimes I have to redo it til I get it right. I'm sure it's simple, but just one of those things.

When I'm adding a text box on a report and want fields to show up, I usually have no problems, but when I want to combine text with those fields, I have problems. I can't get this one going, and I can't see what I've done. Header is OK, footer not. I have more complicated ones in other reports that work just fine.

----------------------------------------------
Header:
[Month] & " " & [Year]
Display: April 2003 (OK)

Footer:
="District Summary by Month " & [Month] & " " & [Year]
Display: #Error
------------------------------------------------

What am I doing wrong? I hate to even have to ask for something so silly!

 

[jeremie_ingram]

Just a thought, but dont the dates need to be enclosed within #'s?

 

[tweetyksc]

Pat,
1 - noted! That's an important point.

2-In this instance, [year] and [month] are fields from the report's underlying query, (in the query it is calculated from the date field). I haven't named these text boxes (still have default txtxxx, I just inserted them on the report have been trying to get them to display correctly. don't have a calculated control anywhere on the report that is named month or year...

What I noticed is even if I copy and past the header text box (which works fine there) and paste it in the footer, it displays "error"

...I'm thinking I'm missing some kind of important point as it relates to procedures here?

 

[tweetyksc]

That's the problem...I'm trying to put it in the page footer.

That's what I'm getting at - is that something that can't be done - putting this in a page footer?

I want the name of the report and the month/year to show up on each page. I have changed all the queries to have MTH, YR instead of the fx names.

I have many other reports where this would be helpful so I'm trying to figure out if this is just not able to be done....ex: in a report where data is run by month--I want the report name and the month to show at the bottom of every page.