When summing a group with time values formatted in "short time", if the value
goes over 24 hours, it displays the time as it would be in the next day.  For
example, if my total time was 25:42, it displays it as 1:42.
Does anyone know how to correct this without having to write ...

I have a report that contains a form header, Detail Section, and Form
Footer.  Today the report produces account number and Amount in the below
listed format.
Account#    Amount

I am currently creating a report and would like to put a border that
encompasses a portion of my page header and all of the the data in the detail
section.  My reports will be two pages so the border on the first page will
span most of the page and on the second page it will need to ...

I have 2 sub reports within the main report, both in the same section. If the
the 1st subreport has > 1 line(record) it prints over the data in the 2nd
subreport. Both sub reports can have varying numbers of records, so I cant
know exactly where to start the 2nd report.

I used page setup to put multiple columns on a single page.  However the
columns do not come out even.  Can I set it so that the columns are specfic
to a section?

I am creating my first database for a physician who does one medical
procedure for one-time patients and then needs to bill the patients after
insurance pays.  
I have created a table "PatientInformation" with the following fields:

I have several clumns in my report and it doesnt fit in the A4 page format,
how do i make all the columns fit in one page
I tried reducing the margin also
Thanks

I have just finished developing a quite complex database (about 50 tables and
100 queries) with some canned reports. There are many data relationships.
Ita all done, tested and signed-off on, but now the user has asked "will I
be able to modify the reports or create my own?"

I have a report that I have set to group by a field.  In the header of that
group, I want to list the value of the field it is grouping on.  I have a
text box with the field name as the control source, but it is coming up
blank on my reports.  I know this is a valid field, ...

I have report that shows data on companies
Each company has sometimes sub company
The report is summerize data of company and sub company
If i have only one sub company the group footer of the subcompany should not

Hi there, similar questions have been asked before but I haven't found
a good solution yet.
I have a report based on a query, which will show 10 columns. Some of
those columns at, however, might be empty, which in that case I don't

I have a query that has 4 different itemtypes three of these types I use in
the heading of my report, the 4 type "m" can have multiple records and I want
to show only the type M in the detail section.  I've been trying to use an
expression in the sorting and grouping Itemtype = M ...

OK, I have a db that tracks Service Orders.  Each Service Order (SO) has logs
associated with them.   The join field is the SO number in a one-to-many
relation.  I needed a report that shows the SO detail and the logs associated
with it....  The report I've created shows the SO ...

Is there any way to allow users to modify and create reports without
compromising the integrity of the database. I guess I need a way of making
all existing reports, forms, queries and modules read-only. Or can I make
them invisible like the 'Sys' prefixed tables. Is there any ...

I'm using VB to change the SQL Record Source of my Sub Form on my Main
form.
On my main form I also have a Command  Button that opens a report.
What command could I use to set the Record Source of my report,