I am using Access 2003 and I have a report that gathers it's data from a
query. The report isgrouped by date and product. Each product has
items(downtime) associated with it. The total product produced comes out fine
but when I do a sum function to show total produce for all ...

I have a report in Access 2000 that is based on a query containing 3 tables
(payment information) with a subreport based on one table (grant budget by
item).  The query has a parameter to limit the data to one grant.  The report
is grouped on budget items.  The body contains ...

I created a query to extract a date by "mmmm, yyyy". It works well, but I
need to sort it cronologically. When I try, it sorts alphabetically. I can
change the formula to "yyyy, mm" and it with sort correctly, but I would like
to display the month (spelled out) and year. Is there ...

I have a report with a subreport for each detail record. I put the subreport
into the group footer of the detail record because I want to be able to make
that section invisible if the user does not want to see the subreport
detail.

I have created a crosstab query to lay out a report with the days of the week
as columns and the week number as rows. I would like to convert the week
number to the date of the first day of that week. How would you write that
code?

hi, i designed a report that is supposed to show the values of three
different queries in form of tables on the report,i achieved this by dragging
the queries onto the report in design view. problem is that now when i run
the report it generates a report page for every single row ...

I have a report that prints job details grouped by jobnumber. There's
usually only 3 or 4 lines in each group. My problem is that the group at the
end of the page splits if there isn't enough space. How can I get the group
to print at the start of the next page if it won't fit onto ...

Is it possible for the header/footer of a MS Access report be a different
width than the Details section?  I have 5 columns set up but want to provide
more detail in the footer horizontally, but it automatically widens the
entire report which causes my columns to be spaced out.

I’m using Access97. I have a report  based on 2 queries. The first query uses
the aggregate sum function to total each employee’s overtime hours (General
number, 2 decimals).  The query groups by social security number and sums
overtime hours. The second query sorts the overtime ...

I would like to center the printout in a text box based on a Yes/No field set
on.  Apparently centering of text is not available in Conditional Formatting.
Is there sample code I can go to for this?
Also I want to set Can Grow and Can Shrink on for this text box.  When

Hi there! Using A02 on XP. Have a few pages that need to
print with certain reports. Except for a few fields at
top, bulk of page is exactly the same for all prints. I
scanned the original to a bitmap and copied and pasted the

I am creating a report based on a query created from a table out of MS project.
The report I'm writing needs to simulate outlining of which is foundin MS
Project.  My report needs the following format:

I need to print reports that have many fields.  My problem is that for
records that have only some of the fields containing information, can I
suppress the remaining fields fjrom the printed report

BlankI'm generating a report that has a section consisting of 66 Check
Boxes.  For any given data row in the underlying table, only one of the 66
options is checked.  Ideally, this would be handled by defining an Option
Group driven by a single data element in the underlying  data ...

(I am new to access) I have a textbox in a form which is bound to a query's
parameter criteria. I defaulted a value on that textbox. When I click on the
'print' button in the form a report prints which is bound to the query. All
this works fine.