Q1- I have label with control source =Count(*) & " " & ("Records") and it
works fine.  I need to have the text placed in front of the =, i.e., to print
as Total records: XX.  I have not been able to find a way to place text in
front of the =.

I am using ACCESS 2007. I am trying to print a report. Paper size is slightly
longer than A4 length. Paper itself is also longer (35 cm). The width is same
for A4. I couldn't find the proper place to set the paper length. So data
beyond A4 region is not printed in the page I want ...

I would like to export my report which contains 4 groups layer to an excel
format without showing all the groups! Exactly the way Crystal Report does.
Could anybody help me with that?
Thanks,

I have an access database report build up complete with parameter query and
some charting and graphing. What is the best way to present the time based
report
thru the websites complete with all the input parameter. Please advise.

I have a report and subreport working just fine as far as outputing the data
I need. The problem is formatting. When I click on properties for the
subreports, there is no column width adjustment. I have been going and
adjusting the column width on the tables serving as a source ...

Is there a way to put a text box in a report from a table not in the field
list and only have one field show. In other words, I tried putting control
source of the text box
=[district table]!school.    That does not work. I can just put =district

Currently working on a project where the client has requested that a
Service Mark be added to a text field - the equivalent of a super-
scripted "SM" by the word.
Anyone know a [slick?] way to do this?

I have a query with a field called "Address"
Address: (qryNames]![HouseNumber]) & (" "+[qryNames]![StreetNameT]) &
(" "+[qryNames]![StreetTypeT]) & (" "+[qryNames]![StreetSuffixT]) & ("
"+[qryNames]![AptNumber]) & (", "+[qryNames]![CityT]+",") & (" "+

I'm creating a "mail merge" type of report that will allow secretaries to
print labels. One example will print a student's name, their homeroom
teacher, and room number. Another example will print the parent's name,
address, city, state, and zip. I want the secretaries to pick ...

I have a form with a command button that has 2 combo boxes beside it.
The 2 comboboxes and named cmbYear (number field from a query) and
cmbMonth( text field from a month table tblMonth).
The coding for the command button is

I have a db with a table that has employee names and dates scheduled for the
year.  Could someone please direct me on how to create a report (or even an
examples of reports) that shows a monthly calendar report for the year with
the employee names for each day.  There can be ...

I have seven crew members who have worked at various parks throughout the
year. My report has all the parks and the hours worked by each crew member.  
How do I calculate the percentage of hours worked at any one park by a member
for the year in a report?

I'm using Access 2007 and deploying a small app with the runtime.  One of the
choices for saving a report is to use the RTF format - which makes it
viewable in WORD.  However, the sole picture in the report - which is saved
in a control of the Type ATTACHMENT does not display ...

I have a report with 2 subreports. Let's say I have 5 screwdrivers, with one
subreport telling me that I have 3- 5" and 2- 6" screwdrivers and the other
subreport telling me I have 2 phillips and 3 straight screwdrivers.
I then have in the same report,hammers, chisels, on and on. ...

Hi everyone!!! Hope your holiday season is going smoothly.  I'm using A02 on
XP.
I have a query that pulls the data I want from my table.  I have a report
with the fields on it.  I have a form with no record source and the following