How to ...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form. Three of the fields are for the clients name ['First Name', 'Last Name', 'Maiden Name']. When printing a report based on the form I have a field called 'Clients Name'. I want to print these three fields found on the form as whole on this single field called 'Clients Name' found on the report.

Thanks.
 
You can't print a report based on a form; a form does not contain any data. It
only displays data from a table, multiple tables or displays data from a query.
A form can be used to set the criteria in a query so your report can only be the
client on the screen or some group of clients. To directly answer your question,
type the following into an empty field in your query based on your clients
table:
MyClient:"[LastName] & ", " & [FirstName] & " " & "(" & [Maiden Name] & ")"

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


ThePro said:
I have a form. Three of the fields are for the clients name ['First Name',
Click to expand...
'Last Name', 'Maiden Name']. When printing a report based on the form I have a
field called 'Clients Name'. I want to print these three fields found on the
form as whole on this single field called 'Clients Name' found on the report.
 
Back
Top