I have a DB report created in Access 2003 that locates comments on
instructors between 2 dates.  The report currently pulls all comments
including those records that have no comments or blank comment fields leaving
huge gaps/white spaces in the report.  What can I do to have ...

Can you please help me with this function.
I have report which pulls out records between two dates(from a query) and
groups them under four groups. I need to count number of records in each
category. i used count(*) in the group footer. it works fine. It shows the

i am getting twice the expected total from my detail section
accumulators.
do access detail section loops execute twice?
what would explain this?

I put this question in the forms area -- it is a form/report problem. - don't
mean to double post, but I should have put it in this area instead. sorry!
hello,
I have a report that shows the detail for 3 different values of a field

I built a report based upon a query that joins two tables: 1) has vendor name
and the total spent on that vendor, and 2)has contract details. My problem:
when there are multiple contracts with a single vendor, the vendor name and
the amount spent prints for each contract, thus ...

I placed an mde file in a network folder. I have no trouble running a copy
from my c drive or from the network folder. The app only has one linked table
in another mdb in another network drive. A user gets  the error "cannot open
F:\.......

I have created a report based on Query, that asks for Begining Date and
Ending Date.
Now in the report I have created to Text Boxes to show the Dates that
represents report. I have thought If I can use the Date field from First

I have a checkbox, chkRetain, that exists on a subform.  When users have it
checked, and they run a particular report, rptProposal, I'd like the
following text to be displayed in one of the group footers:
"This proposal is for material supply only and subject to 0% retainage.

Hiya,
I am making my PDF report just fine but I would like to autoname the report
and even the save location if I can.
I have done this in the past but for the life of me cannot remember exactly

I know this is very simple but I am not able to figure it out.  I would like
to convert a date that is stored in short date format to long date format
without the day of the week.
Example:

I have a pie chart in the detail section of a report. The select query
(recordsource) is summing the items and is filtered by date criteria from my
report form and looks like this: ([Opened] >=#01/01/2007#) AND ([Opened] <=
#03/31/2007#). This produces multiple records for each ...

My Access db is linked to SQL db's.
I created a report then ran my mde and the users open the mde.
One date on the report returns incorrect on every PC except mine.
If I'm at a different PC open the mde the date is incorrect.

Another (hopefully) easy one...I get an employee table from another
department with the following pieces of data:
deptid
mgr name

Olá!
Estou fazendo um relatório e preciso fazer um total dos valores apresentados
de acordo com 3 critérios, porém, sem sucesso. Alguém poderia me ajudar a
identificar o problema da expressão ou qual a melhor maneira de fazer essa

I am trying to make a report so the first dataset (row) is to the left, the
second to the right, then the third below the first, and so on.  I could
create two subreports if I knew how to autonumber the query (have the
subreport on the left only pull odd autonumbers).  Any ...