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

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Query multiple fields to one    
 
   
boxofrox
post Sep 24 2004, 10:19 AM
Post #1

UtterAccess Enthusiast
Posts: 67
From: LV, NV
I need to query 3 fields (length, width and thickness) into one. Currently the three fields are part of a very large query through which I generate a report. Do I need a separate query to build this and then include that query in the final larger query? or is there a way to include it in the current query? (was that confusing enough for everyone???)

Cindy
Go to the top of the page
 
+
danishani
post Sep 24 2004, 10:23 AM
Post #2

UtterAccess VIP
Posts: 4,162
From: Washington, USA
hi Cindy,

Well, u can add them together in your report, which probably a easy way:

In an unbound textbox u can do something like this, do u want to seperate them by a space or do u want them all together in one line:

all seperated with a space:
=[length]&" "&[width]&" "&[thickness]

all without a space:
=[length] & [width] & [thickness]

HTH
Daniel
Go to the top of the page
 
+
boxofrox
post Sep 24 2004, 10:32 AM
Post #3

UtterAccess Enthusiast
Posts: 67
From: LV, NV
So basically I can leave the query the way it is and just combine them in the report - I knew it was absurdly simple... must have more coffee.


Thanks!

Cindy
Go to the top of the page
 
+
danishani
post Sep 24 2004, 10:39 AM
Post #4

UtterAccess VIP
Posts: 4,162
From: Washington, USA
Cindy,

Yes, well u can do it a query, but can give some trouble if its all combined from a lot of calculations, so in this case its maybe better to do this in your report.

Daniel
Go to the top of the page
 
+
boxofrox
post Sep 24 2004, 10:43 AM
Post #5

UtterAccess Enthusiast
Posts: 67
From: LV, NV
Need more braincells to go w/ the coffee: where does the code string go?
Go to the top of the page
 
+
preston
post Sep 24 2004, 10:53 AM
Post #6

UtterAccess Ruler
Posts: 1,692
From: Nevada
Place his recommended string:

=[length]&" "&[width]&" "&[thickness]

in the Control Source of the textbox you want to show it. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/frown.gif)

You in Las Vegas or Reno?
Go to the top of the page
 
+
boxofrox
post Sep 24 2004, 11:03 AM
Post #7

UtterAccess Enthusiast
Posts: 67
From: LV, NV
I'm in Vegas - I'm getting a very strange string in the textbox after I put this code in. I put in three arbitrary numbers in Length/Width/Thickness - 2/3/1 - and I get 2 x 4050 x 1

Ideas?

Cindy
Go to the top of the page
 
+
preston
post Sep 24 2004, 11:31 AM
Post #8

UtterAccess Ruler
Posts: 1,692
From: Nevada
Can you attach a sample database?

I'm in Las Vegas as well.
Go to the top of the page
 
+
boxofrox
post Sep 24 2004, 11:44 AM
Post #9

UtterAccess Enthusiast
Posts: 67
From: LV, NV
Well the db is very large. The field actually exists in a subreport.
Table - Query - Form - Subreport
The fields are text fields. There are no other code strings operating w/in the subreport.

hope this helps
Go to the top of the page
 
+
preston
post Sep 24 2004, 12:02 PM
Post #10

UtterAccess Ruler
Posts: 1,692
From: Nevada
Is the field named Width? It may be a reserved word. Maybe try changing that field name?
Go to the top of the page
 
+
boxofrox
post Sep 24 2004, 12:06 PM
Post #11

UtterAccess Enthusiast
Posts: 67
From: LV, NV
Yup! That was the problem - thank you so much. Where are you in NV?
Go to the top of the page
 
+
preston
post Sep 24 2004, 12:45 PM
Post #12

UtterAccess Ruler
Posts: 1,692
From: Nevada
I live on Silverado Ranch, Work over off Sunset by the Airport.
Go to the top of the page
 
+
« Next Oldest · Access Queries · 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: 19th June 2013 - 08:06 PM