Reports - Formating a line of text with variables

  • Thread starter Thread starter The Boondock Saint
  • Start date Start date
T

The Boondock Saint

is there a way you can string togeather a line in reports including
variables from a query..

what id like is to have the variable ABC and variable DEF put into a
sentance such as

lets say ABC = 123
and DEF = 456

firststringoftext=ABCandhereisanotherbitoftextDEF
firststringoftext=123andhereisanotherbitoftext456

ABC and DEF will have variable lengths.. like one might be 5 charactors...
and one might be 20 etc....

any ideas?
 
"Variables from a Query"?

Do you perhaps mean "Fields in a Query that is used as the RecordSource for
the Report"? If so, then you could use in the ControlSource for the Text box
where you want to display the string:

= ABC & "andhereisanotherbitoftext" & DEF

Larry Linson
Microsoft Access MVP
 
thanks Larry...
I found an example on a website .. and i did it like this
=[ABC]&[TEXT1]&...........
I put the TEXT1 value in the query itself...

thanks for the help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

updating a table based on data in same table 2
Formatting Sheet 5
Need to Change An Output Report... 3
Concatenation of data based on a common field 1
Assign a variable to a text box 2
Try again?? 11
Ranking Records with multiple criteria. 1
Quering Table 5

Back
Top