A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Concatenation for JulieD or any other Guru



 
 
Thread Tools Display Modes
  #11  
Old October 7th, 2004, 01:23 PM
JohnLute
external usenet poster
 
Posts: n/a
Default

Yikes - my brain is toast. I originally built the report with the wizard and
all is well except that I can't understand why I can't concatenate it, either!

You say into "another" field. I'm new to concatenating and I don't follow.
You mean create another text box next to Style and have it concatenate...?

I'm not able to picture this.

"Allen Browne" wrote:

John, if the Style field is in the report's query, and it shows in the
FieldList for the report, I don't understand why you cannot drag it from
there onto the report, and concatenate it into another calculated control.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

  #12  
Old October 7th, 2004, 01:23 PM
JohnLute
external usenet poster
 
Posts: n/a
Default

Yikes - my brain is toast. I originally built the report with the wizard and
all is well except that I can't understand why I can't concatenate it, either!

You say into "another" field. I'm new to concatenating and I don't follow.
You mean create another text box next to Style and have it concatenate...?

I'm not able to picture this.

"Allen Browne" wrote:

John, if the Style field is in the report's query, and it shows in the
FieldList for the report, I don't understand why you cannot drag it from
there onto the report, and concatenate it into another calculated control.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

  #13  
Old October 7th, 2004, 02:14 PM
Allen Browne
external usenet poster
 
Posts: n/a
Default

I'll let you take it from there, John.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JohnLute" wrote in message
...
Yikes - my brain is toast. I originally built the report with the wizard
and
all is well except that I can't understand why I can't concatenate it,
either!

You say into "another" field. I'm new to concatenating and I don't follow.
You mean create another text box next to Style and have it concatenate...?



  #14  
Old October 7th, 2004, 02:14 PM
Allen Browne
external usenet poster
 
Posts: n/a
Default

I'll let you take it from there, John.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JohnLute" wrote in message
...
Yikes - my brain is toast. I originally built the report with the wizard
and
all is well except that I can't understand why I can't concatenate it,
either!

You say into "another" field. I'm new to concatenating and I don't follow.
You mean create another text box next to Style and have it concatenate...?



  #15  
Old October 7th, 2004, 03:03 PM
JohnLute
external usenet poster
 
Posts: n/a
Default

I really don't understand but thanks, anyway!

"Allen Browne" wrote:

I'll let you take it from there, John.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JohnLute" wrote in message
...
Yikes - my brain is toast. I originally built the report with the wizard
and
all is well except that I can't understand why I can't concatenate it,
either!

You say into "another" field. I'm new to concatenating and I don't follow.
You mean create another text box next to Style and have it concatenate...?




  #16  
Old October 7th, 2004, 03:03 PM
JohnLute
external usenet poster
 
Posts: n/a
Default

I really don't understand but thanks, anyway!

"Allen Browne" wrote:

I'll let you take it from there, John.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JohnLute" wrote in message
...
Yikes - my brain is toast. I originally built the report with the wizard
and
all is well except that I can't understand why I can't concatenate it,
either!

You say into "another" field. I'm new to concatenating and I don't follow.
You mean create another text box next to Style and have it concatenate...?




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Concatenation Shawn Worksheet Functions 5 August 19th, 2004 06:00 PM
Concatenation Mike Gudyka Worksheet Functions 4 August 10th, 2004 01:09 PM
Concatenation giving #VALUE error? denisecook Worksheet Functions 0 May 4th, 2004 03:13 PM
date concatenation confusion spence Worksheet Functions 3 April 5th, 2004 09:04 PM


All times are GMT +1. The time now is 09:11 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.