I built a crosstab query (w/ out the Wizard - thanks Rick) that has days of
the week as the column heads that sum the amount of business done per day (by
hour - which is the rows). This works fine if there are sales to add for each
day. However, if there are zero sales that fit ...

I have a combo box in a form that list all the tables in the database. How
do I use a selected table for a pre made report. All the fields are set up
in the report. The thing I need it to do is to use a selected table for the
Record Source. Thanks for any help.

I have created a text box that pulls data from a subform and outputs the
result.
My problem is when there is no value it ouputs an #error, instead of the
error I would like to  $0.00

I am trying to create a report that pulls information for an individual
student.  I want the end user to choose a student's name from a drop down box
in a form (pulling from a Student table) and then from the form preview and
print the report.  I've created a query that has a ...

I have created a report where it sorts first by a group and then by a date.  
Then gives me a total per group.
The result of my report is the following:
Equipment (group header)

I have a report that lists class schedule.  It first needs to be sorted by
days of week.  Unfortunately, the data dump that provides the courses for the
database, uses M T W U F for the days of the week.  So when I sort on that
field, I get all the Friday Courses first, instead ...

We need to number each line in a report in the Detail area
Help doesnt show anything on this .... any suggestions
Thanks
Chris

I have created a CrossTab query that I wish to create a report from.
However the query has column headings that will be added as data changes
in the database. i.e. New teams being entered after design of report.
Example: There are only ever 3 Titles, but the number of teams can grow ...

I can't imagine how this could be done, but...is there any way to print the
second page of a report twice. That is to say, in a two-page report i would
like to print the first page once and the second (last) page twice. Note that
the second page is initiated with a page break ...

Is there a way to convert a number to show feet and inches in a report?

Programmically, is there a way to program Access check if the date is the
last Monday of the month?  I thought about creating a date table with the
last Monday of the month and have Access run the query if the current date is
in the table, but this may require user maintenance.  ...

Is there a way to control which table is used in a report other then
changing it in design view - Record Source.

I have a report that has 3 parameters (office, year, month) that are
displayed on the report.  At the end of the report there is a label that
provides the title of the summary section.  I would like to have the label
not only say "Provisions Outcome Summary" but also to include ...

I have a main report contains 8 subreports. The main
report is just the place holder with some header
information.  I want to display each subreport on a new
page. This works fine when subreport has data. But it give

My main report has a group footer that has to print a sub-report.  The
sub-report can be 1 of 2 that are available.  
rptJoint
rptJointNone