UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Report gives error when concatenating fields    
 
   
repasky
post Mar 16 2004, 05:30 PM
Post #1

UtterAccess Addict
Posts: 184
From: Pennsylvania
I know I have had this problem before, but I can not seem to resolve this. I have a report where I want to print 2 files together and put a slash in between.

Like this:
[tField1] & "/" & [tField2]

I get #error. Both fields are from the same input table.

I tried Ltrim () function also, but does not work.

What do I do?

Al
Go to the top of the page
 
+
kuifjexx
post Mar 16 2004, 06:12 PM
Post #2

UtterAccess VIP
Posts: 7,232
From: Belgium
The control source must be =[tField1] & "/" & [tField2]

Do not forget the '='

Greetz from Belgium (IMG:http://www.utteraccess.com/forum/style_emoticons/default/compute.gif)

Luc aka Kuifjexx
Go to the top of the page
 
+
repasky
post Mar 16 2004, 06:16 PM
Post #3

UtterAccess Addict
Posts: 184
From: Pennsylvania
Sorry, I forgot the '=' sign in the message, but it was not forgotten in the program. It just does not work.

Al
Go to the top of the page
 
+
mvos
post Mar 16 2004, 06:19 PM
Post #4

Utterly Certified UA VIP
Posts: 7,563
From: Worcester, England
Hi,

Are [tField1] and [tField2] text or numeric fields?
Go to the top of the page
 
+
kuifjexx
post Mar 16 2004, 06:21 PM
Post #5

UtterAccess VIP
Posts: 7,232
From: Belgium
Can you give us info about the datatypes and contents of the fields?

Greetz from Belgium (IMG:http://www.utteraccess.com/forum/style_emoticons/default/compute.gif)

Luc aka Kuifjexx
Go to the top of the page
 
+
repasky
post Mar 16 2004, 06:23 PM
Post #6

UtterAccess Addict
Posts: 184
From: Pennsylvania
=[tMaintMonths] & "/" & [tMaintMiles]

This is the actual entry that I am trying to print.
Al
Go to the top of the page
 
+
repasky
post Mar 16 2004, 06:25 PM
Post #7

UtterAccess Addict
Posts: 184
From: Pennsylvania
They are both text fields. One is 4 chars and the other is 10 chars.
Al
Go to the top of the page
 
+
mvos
post Mar 16 2004, 06:28 PM
Post #8

Utterly Certified UA VIP
Posts: 7,563
From: Worcester, England
What happens if you do this in the query instead

fldCombined:[tMaintMonths] & "/" & [tMaintMiles]

and then use fldCombined in the report.
Go to the top of the page
 
+
repasky
post Mar 16 2004, 10:39 PM
Post #9

UtterAccess Addict
Posts: 184
From: Pennsylvania
John,

Sorry, I left my computer for the evening and just got back. With the 5 hours difference, you will not see this until tomorrow.

Thanks, that did it. I never knew you could do that trick. Works great.

I have had this problem before, and I know it should have worked the original way.

Al
Go to the top of the page
 
+
« Next Oldest · Access Reports · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 25th May 2013 - 01:21 PM