CAN I PRINT AN ACCESS REPORT IN THIS FORMAT?

  • Thread starter Thread starter Dave Reid
  • Start date Start date
D

Dave Reid

I wonder if anyone could help me with access reports. I have a database
containing only one table. I have created various queries re the database
successfully. I have been asked to create reports in respect of certain
aspects of this database. When I created some of the reports the end result
is always a list of information. One of our team would like the reports to
state a specific amount eg. Joe Bloggs saw x amount of clients referred to
him by John Smith in 2004. She has assured me this is possible, but does
not know how to do this. She does not want any charts or graphs, just
specific printable figures.

As I have only done a beginners and intermediate course on Access I am
somewhat of a novice and would appreciate any help I can be given regarding
my problem.

Thanks in anticipation.

Fiona
 
You can set a control source to something like:
=[empFirstName] & " " & [empLastName] & " saw " & [CliCount] & " amount of
clients referred..."
 
Replying on Behalf of my wife:

I posted your reply on to my wife at work (thanks for replying btw) and her
exact words were "Say What??" I think what she means is, is there anywhere
on the net (or in the help files) that she could look to try and find out
how to action your answer. Like she said, she is a novice and this "Team"
member is hounding her something terrible...

David Reid

Duane Hookom said:
You can set a control source to something like:
=[empFirstName] & " " & [empLastName] & " saw " & [CliCount] & " amount of
clients referred..."

--
Duane Hookom
MS Access MVP


Dave Reid said:
I wonder if anyone could help me with access reports. I have a database
containing only one table. I have created various queries re the database
successfully. I have been asked to create reports in respect of certain
aspects of this database. When I created some of the reports the end result
is always a list of information. One of our team would like the reports to
state a specific amount eg. Joe Bloggs saw x amount of clients referred to
him by John Smith in 2004. She has assured me this is possible, but does
not know how to do this. She does not want any charts or graphs, just
specific printable figures.

As I have only done a beginners and intermediate course on Access I am
somewhat of a novice and would appreciate any help I can be given regarding
my problem.

Thanks in anticipation.

Fiona
Click to expand...
Click to expand...
 
You can create a report based on your table or preferrably a query. Assuming
you have field names in the query like [empFirstName] and [empLastName] and
[CliCount]... you can add a large test box in the detail of the report. Set
the Control Source property of the text box to:
=[empFirstName] & " " & [empLastName] & " saw " & [CliCount] & " amount of
clients referred..."
This "merges" your fields into a paragraph format.

You/she should also consider publishing the information in Word.

--
Duane Hookom
MS Access MVP
--

dr_bod said:
Replying on Behalf of my wife:

I posted your reply on to my wife at work (thanks for replying btw) and her
exact words were "Say What??" I think what she means is, is there anywhere
on the net (or in the help files) that she could look to try and find out
how to action your answer. Like she said, she is a novice and this "Team"
member is hounding her something terrible...

David Reid

Duane Hookom said:
You can set a control source to something like:
=[empFirstName] & " " & [empLastName] & " saw " & [CliCount] & " amount of
clients referred..."

--
Duane Hookom
MS Access MVP


Dave Reid said:
I wonder if anyone could help me with access reports. I have a database
containing only one table. I have created various queries re the database
successfully. I have been asked to create reports in respect of certain
aspects of this database. When I created some of the reports the end result
is always a list of information. One of our team would like the
Click to expand...
reports
to
state a specific amount eg. Joe Bloggs saw x amount of clients
Click to expand...
referred
to
him by John Smith in 2004. She has assured me this is possible, but does
not know how to do this. She does not want any charts or graphs, just
specific printable figures.

As I have only done a beginners and intermediate course on Access I am
somewhat of a novice and would appreciate any help I can be given regarding
my problem.

Thanks in anticipation.

Fiona
Click to expand...
Click to expand...
Click to expand...
 
Back
Top