Given that the RTF renderer in Access seems to be slightly bust in that it
truncates text, does anyone have any other suggestions as to what output i
could use.
i have tried HTML which would work, apart from the fact that when the output

I have a report that has fields such as CustomerName,
TxnNumber, TxnDate, ItemNumber and ItemName.  I created a
report that grouped by CustomerName and has the other
fields listed in the  report.  What I want to do now is

I put this expression in a textbox on my report:
=DCount("[Importancia]","totals2","[importancia] = 'A' ")
The result = 91
But when I go back to my query and do a filter on field that contains the A

I am using Access 2000. I am trying to create a report using two queries,
when the report is created it is creating duplicates of information which is
singular whilst emmiting information that should be included. How do i
correct this problem?

I have a table with a field called InOut. The values in this field are
either I or O. They have corresponding start dates and end dates. So for
example, a record might have an InOut value of O and a start date of 01/03/05
and an end date of 15/03/05. I want to create a report ...

I have a Field called Agent that contains "none" and details other than none
I need to show in a report a Count of ""none" cases & a Count of the other
entries. It has to be this way because the maindata Table will be updated
monthly.

Dear Group,
I'm having a problem with designing queries for subreports.  I'm
selected a group of records for the subreport where I want to limit
the set accoring to a field specified in the main report. It looks

I have a template that is dictated by our company for standard reports.
rather than re-create the template now (and next time they revise it) as an
access report, I want to put a button in my access forms that allows users
to create a word document, populated by the data in that ...

I have written a very complex report. Its not a normal report. I build a
custom table which just consists of detal lines. Hundreds of SQL calls are
used to build this table. This table becomes the report control source. My
problem is that the first column needs to print as bold ...

Yes, I am trying to complete a database I built a couple of weeks ago, and
I'm having trouble with the report part of it. I basically have several with
different fields, 23 different fields to be exact. I built the report but
some of the entries only require two of the fields to ...

Yes, I am trying to complete a database I built a couple of weeks ago, and
I'm having trouble with the report part of it. I basically have several with
different fields, 23 different fields to be exact. I built the report but
some of the entries only require two of the fields to ...

Yes, I am trying to complete a database I built a couple of weeks ago, and
I'm having trouble with the report part of it. I basically have several with
different fields, 23 different fields to be exact. I built the report but
some of the entries only require two of the fields to ...

My report is based on a param query.  textbox1 shows these 2 params.  ok so
far.  But it's a bit ugly to see just numbers in the box instead of
something more informable on a report.
So I thought can I define an unbound textbox2 and to show a more human

I'm setting up a report that I want to show the following information in a
table format:
Item #   Description   Unit   Est. Qty    Actual Qty    Cost     Total Cost
I currently have an access table set up with the item #, description, unit,

Basically I created a report for the inventory here and grouped by name of
user but I don’t want a name to show up at the end of a report page with the
users equipment listed on the next page. Is there away to create a page break
for when data will be spread across two pages?