I found some direction in an older thread from JulieD to Dave about
concatenating. I've tried to apply it to my report but have been unsuccesful.
Here's JulieD's post followed by my challenge:
Hi Dave

Hello Access Nation
I've created a report in which I have hidden the
duplicate entries.  When the report runs I'm left with
blank space between the entries in the detail section.  

Obviously I'm missing something somewhere but I can't seem
to find the answer to solve this. I open my db, I select
my report, I print the report, so far so good. Now I want
to back to the switchboard to continue in the db but when

I have a report that needs a from date and a to date (10/1/2004 to
10/7/2004).I have this report from a parameter query that requires you to
enter these two dates but it does not show up on the report.How can i place
these dates on the report?

I'm using Access 97 and have a TextBox in a report which has the following as
its ControlSource =[Equipment Nomenclature]&" / "&[Equipment Name].
Is there someway that I can prevent the "/" from appearing in the report if
either the Equipment Nomenclature or the Equipment Name ...

I have created an Access data base and I have created a macro to run 3
reports at once.  
Each report has the same report criteria EG: Date from: / Date to,  and I am
wondering how to run these reports without having to answer the same question

HOW DO I CAREATE A REPORT THAT PULLS INFORMATION FOR A SPECIFFIC DATE RANGE

I have a 2-3 page report.
When I print, it comes out with totally blank pages in
between each report page. (Not even page footer appears!)
How can I get round this?

Hi again,
In order to solve the problem I mentioned in my last
question, I tried to create a function that should return
the string with the criteria of the query and in the

    Im new to access and creating databases in general. I was
woundering how to take information from my form and put it in to a report.
    I have a workorder form that pules from 3 tables. workorders,
workorderparts, and workorderlabor.

    Im new to access and creating databases in general. I was woundering
how to take information from my form and put it in to a report.
    I have a workorder form that pules from 3 tables. workorders,
workorderparts, and workorderlabor.

i need help from experts,
i use ForceNewPage = After Section. in my report resulting
3 page with has subtotal at current section.
but report footer (grand total) show up on separated pages,

I have two completely seperate databases - running at the same time with the
same information available on them, I need to pull the information from both
data bases into one report for a overall summary report is this possible???  
I have linked both tables into the same access ...

Upgraded to ACCESS2003 and now cannot create a report or get a design view of
a report. Already un & re-installed to no avail. Previous databases open up
but cannot run existing reports, cannot open design view, cannot create new.
All other functions (query, tables, macro, etc.) ...

Can anyone help get me started in the right direction as
far as creating box labels where each label will have a
line of text "Box 1 of 5", the next "Box 2 of 5" etc.