The following is what I use in an Access program for the same thing you are doing. Listed below are the actual fields in my first address label query:
Name: Trim(UCase([Client_First_Name])) & " " & Trim(UCase([Client_Last_Name]))
City_Label: Trim(UCase([Client_City])) & " " & Trim(UCase([Client_country])
Client_Address: IIf([tblClient]![Client_Street_Address_2]<>"",[tblClient]![Client_Street_Address_1] & Chr$(13) & Chr$(10) & [tblClient]![Client_Street_Address_2],[tblClient]![Client_Street_Address_1])
Post_Code: Trim(UCase([Client_Postal_Code]))
NOTE: The Client_Address makes sure that if the Street_Address_2 field is blank that it doesn not inlude the CR and LF as it would create a blank line between Street_Address_1 and the Postal_Code.
The create a second address label query based on the above query that consists one one field with the expression:
Address: [Name] & Chr$(13) & Chr$(10) & [Client_Address] & Chr$(13) & Chr$(10) & [City_Label] & Chr$(13) & Chr$(10) & [Post_Code]
You can then set your report record source (use a subreport if you have to) to the second address label query and voila!
You could do the above it one query using a field with a really long expression I just seprarated it into 2 for ease of reading.
s for the spreadsheet I am able to link to an excel spreadsheet and append to it from Access with no problems. So to figure this out why don't we get a little more detail. What is the EXACT error message that comes up word for word? Are you using Access 97 and Excel 97 or combinations of 2000? Does it work with a simplified append query (by this I mean just try doing one column to start prefereably one that is simple text)?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement