473,387 Members | 1,799 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

How to combine two fields together in a report in Access?

36
I am trying to combine forename and surname together in a report so, that there is only a single space between the two. Any help would be much appreciated. hope someone can help me with this problem. Thanks
Apr 9 '07 #1
2 25502
VictorS
12
Create a new unbound text box in detail section.
Set control source property to the following:
=[Forename]&" "&[Surname]
Apr 9 '07 #2
atiq
36
Create a new unbound text box in detail section.
Set control source property to the following:
=[Forename]&" "&[Surname]
Sorted! nice one mate. i forgot to to add the '&' which is why i though i'd get expert help. once again thanks.
Apr 9 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: JC Mugs | last post by:
I have a report coming from a query that I need to print. Question: I want to have fields print or not print on a value of one of the fields... Like this- IF Doz2 >0 then Print Doz2 ...
3
by: CSDunn | last post by:
Hello, I have a situation with MS Access 2000 in which I need to display report data in spreadsheet orientation (much like a datasheet view for a form). If you think of the report in terms of what...
2
by: mlb5000 | last post by:
I am creating a form that needs to read information from another table. The user selects a single value from a drop-down box that is linked to the first column of data in the table I want to read...
6
by: adej | last post by:
How do i connect 2 pcs together to access internet at the same time
10
ryanvmcgee
by: ryanvmcgee | last post by:
Hello, I am fairly new at doing advanced databases outside of excel. I am trying to combine records in a database I will be using, none of the, CONCAT Queries or scripts I have found seem to...
3
by: atiq | last post by:
I am tyring to join two join fields together in a Report in the follwoing format: Date: Time: i have attempted this using the following code, but doesnt work: ="Date:" & " " & & " " &...
5
by: LadyIlsebet | last post by:
I'm not a fantastic Access developer, but I'm trying to help get Inventory and whatnot organized at work. They are used to 5 year budget plans that list out exactly what has to be purchased what...
2
by: KD5588 | last post by:
I am trying to combine LastName, Prefix and FirstName in one field in a report. The syntax doesn't error out, but when I run the report it asks for the LastName and FirstName. If I don't put...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.