I used the wizard to create a form.  Everything is fine except I want to
have the subtotals under the group headers but the default is for the
opposite.  Is there a way of 'dragging and dropping' the detail line?

I am working on a database that requires a report in which interest is a
cumulative total from 1/1/2007 thru todays date.  The other information that
needs to go in the same report is the dollar amount of investments made in a
specific month.  Both of these totals are associated ...

I have a 3 column report.  I want the fields in the 3 columns to line up but
don't know how to do this.
For example, right now my report looks like this:  Note where Field 2 is
appearing in Column 2.  I want it to line up with the other field 2's in

Have a query that has my units mtoe that is used for usr. now I have a column
(Sex) that when I put a soldier in the authorized spot that comes from my
units data either puts in a f for female or m for male. Is there a expression
that I can but in another column that buts a number 1 ...

Using Access 2003.  I am trying to calculate the total of hours worked by
tutors by summing the totals from the timetable.  The problem arises if a
tutor is timetabled in room A on Monday between 1 and 3, and also in room A
on Monday between 1 and 2 - a straight sum will double ...

Dear friends,
I receive an error msg "Microsoft Access can't find the field 'unitweight'
referred to in your expression" allthough the field is there and belongs to
the record source.

I have a requirement to color code labels and reports based on criteria
contained in the report data. The database is for VHS and DVD movies and the
requirement calls for the printed reports and labels to have the media number
color coded based on the genre. For example, Horror ...

When attempting to preview a certain Access report created with the report
wizard, the following message appears: "The wizard is unable to preview your
report, possibly because another user has a source table open in exclusive
mode. Your report will be opened in design view." If ...

I have a table of about 500,000 records for which I need to find exceptions
in.  The exception is a negative quantity in a footer3 of a report I have
designed.  I have changed Footers 1 & 2 to not be visible (unless I need to
see the details of something - I can re-activate them) ...

Specifically I would like to print several reports to a pdf file and end up
with a single document.

Good morning,
I am creating a report of inventory of boxes.  In each box, we have folders.
The report will show a record for each folder, instead of a record for each
box.  

I have a report that I am trying to print according to start and end dates. I
have the "report date range" form tied to this report. When I run this
report, I get asked to input the start and end dates, but after typing in
these dates, the report still doesn't sort; instead, it ...

I have a report that draws the CompanyFrm from the form. I need the report to
know when TSWS, Inc is selected the TSWS, Inc. logo show up in the report
instead of the address... Can someone help me? Thanks

I have a report that has several rows and colunms as follows. I have it set
up if a check box is true to shown all the colunms in that row. What I need
now is, if row 2 is null (all blank) I want row 3 and row 4 to move up into
row 2's position so it will not show a blank where ...

I've developed a custom report in design view (didn't use the wizard at all)
that shows summary statisitcs for an entire state and then by region.  The
state's statistics are shown in the report header and each each region's
statisitcs are shown in the "Region" section that was ...