If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Report Labels
I created two different label reports from imported Excel files using the
report label wizard that work just fine. The reports are based on queries based on tables input from the Excel files. I went to do a third label report and so on and every time I run the report I get #error where the person name is suppose to be. The label report design that's working looks like this: =Trim([FULL NAME]) =Trim([PRIMARY ADDRESS]) =Trim([CITY] & ", " & [STATE] & " " & [ZIP+4]) The label report design that's not working looks like this: =Trim([Report]!Name) =Trim([Address]) =Trim([City] & ", " & [State] & " " & [Zip]) NOTE: The above are all built from queries using different tables. As is, I get #ERROR in place of person name on label sheet. If I change the not working model to look like the working model (remove REPORT so it looks like -Trim([Name])), I get the name of the report in place of the person name. Why this problem surfaced after building two reports that work just fine is beyond me. When I run the query based on the table with the info, I get the person name. Any help will be greatly appreciated and thanks in advance. KP |
#2
|
|||
|
|||
Report Labels
Ken wrote:
I created two different label reports from imported Excel files using the report label wizard that work just fine. The reports are based on queries based on tables input from the Excel files. I went to do a third label report and so on and every time I run the report I get #error where the person name is suppose to be. The label report design that's working looks like this: =Trim([FULL NAME]) =Trim([PRIMARY ADDRESS]) =Trim([CITY] & ", " & [STATE] & " " & [ZIP+4]) The label report design that's not working looks like this: =Trim([Report]!Name) =Trim([Address]) =Trim([City] & ", " & [State] & " " & [Zip]) NOTE: The above are all built from queries using different tables. As is, I get #ERROR in place of person name on label sheet. If I change the not working model to look like the working model (remove REPORT so it looks like -Trim([Name])), I get the name of the report in place of the person name. Why this problem surfaced after building two reports that work just fine is beyond me. When I run the query based on the table with the info, I get the person name. That's to be expected when you use a reserved word for a field, control or variable name. Access thinks your [Name] field is referring to the report's Name property. The best thing to do is change the name of the name field in the table, but, since you are getting the data from Excel, that may not be under your control. If necessary, create a query that provides an alias name for the name field. -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Reporting subreport total on main report | BobV | Setting Up & Running Reports | 22 | November 1st, 2005 03:19 AM |
from a FORM print a label report 3 labels per sheet for CURRENT re | babs | Setting Up & Running Reports | 7 | February 6th, 2005 06:38 PM |
Still Hoping for help with a Query problem | Don Sealer | Using Forms | 15 | November 13th, 2004 06:24 AM |
Creating a mailing labels report using the labels wizard | M. A. van Schaik | Setting Up & Running Reports | 1 | October 6th, 2004 09:57 PM |
Label | SRIT | General Discussion | 2 | June 22nd, 2004 09:42 PM |