I have a table with many records.  The primary key or record Id is quite long
and complicated to type. Is there an easy way for the user to be able to pick
the record they want to print for a report without having to type in the
complex key field to ask for the record they ...

I have a month end report that includes several sub reports.  The problem I
am having is when I move a sub-report in design view just slightly, it seems
to move a couple of inches when printed?   What am I missing here?  Does
anyone know what is causing this?  I really need about ...

I am trying to make wildcard expressions work for filtering . To pass
everything, I tried Filter = "strFC = '*'" but that passed nothing. I can't
find this documented. Can i use wildcards as filters?

I have a main report, rptEmployees.  The sub is subrptEmployeeDegrees.  They
have different queries and are linked by txtParticipantId.  I counted the
employees [txtEmployees] on the main report footer (223). I counted the
number of degrees [txtDegrees] in the subreport (120) ...

i have a report with a few columns how do i make it that the page header and
footer spans the width of the whole page and not just of the first column

The following code is failing with error  2455 ("You entered an expression
that has an invalid reference to the property ZoomControl")
  DoCmd.OpenReport "rptTAD", acViewPreview
  Reports("rptTAD").ZoomControl = ReportZoomPercent

I'm trying to add a last note date field into a form that will reflect this
date in a report.  My question is this: how do I link the report date field
to reflect this info into a report with a column named "Last Note Date"?  I
hope this is enough explanation for a response.

I have a table with more than 30,000 records. I want to put Sem and Rundate
fields to the report header.  These two fields looks like this:
Sem        RunDate
0              20070214

Currently I have a query that states Nights:[CheckOutDate]-[CheckInDate].
The problem is that I am putting a parameter of Between two dates in the
checkin field.
Nights: IIf(DateDiff("d",[CheckInDate],IIf([CheckOutDate] Is

If you have multiple sub reports derived from multiple queries that all ask
for a data parameter.  Is there a way to enter this once for all of them
instead of multiple times?

Anyone experience a problem w/a running sum over a group in an access 2007
report?  Text field works fine if set sum for 'Over All', but if set to 'over
group', the control value stays at 1
thanks

I have a form with yes no buttons for people to select things. For instance,
if a person wants to send a business card they click on the business card
button on the form.  I then created a report based on all of the selections
that people make.  The values are all 0 and 1 on the ...

I have sales data that I would like to create a report on.  This report would
count the number of events based upon the total and seperate them by year.  
In Excel it looks like this:
                              2003     2004     2005    2006    2007

I used Duane's sample to create a daily schedule (thank you!!).  
I'm trying to make a slight modification and instead of showing the
dashes/slash marks for the times at the left side of the page, I wanted a
solid line to go across the page at each hour.  No problems there, ...

I have a report that tracks sales totals with the date, month and amount in
the Detail section.  I have a yearly total calculated by summing the amount
in the Year Footer.  At the bottom of the report I want to have an average
for all years.  So for the example below the average ...