The source query is using "totals" and the condition for the memo field is
set to "First". This displays the entire contents of the memo field (more
than 255 chars), vs using "Group By" which truncates the field to 255 chars.
However, even though the entire string displays in the ...

I created a 6 column report that is working fine, now I am adding a subreport
it only fills in one column per page not like the main report.  Need help.  
Thnxs

You see we have an access report called Invoiced Shipments Report.  It is
created where in you can put the date range for all or each customers.  If
you want only certain customers you have to type in the customers you only
want and if you want all customers you just have to ...

I am trying to build a large report in access and it tells me there are too
many fields.  I'm working with 70 fields.  Does anyone know a workaround?

Can anyone advise me as to how to include grid lines on an Access XP report
set out in landscape format.
Thanks in advance.
GLS

WinXP Pro - Office 2003
I have many cbo boxes on my report (created by saving my form)
On one of them in the upper left hand corner there is a triangle of
color, I don't know why it is there.

I have a report with a bound control called [TransDate] (in dd/mm/yyyy
format).  There is another unbound text box called [DateRange].  I would like
to display the text "1-30 January YEAR" in [DateRange] for every record where
the [TransDate] is in January regardless of the year, ...

I have two tables in sql database as follows.
I need to generate the output given at the end.
=======
Table1

I need your help to build in a form.
I want to build in a form so that it provides mulitple boxes for the reveune
amount and then total amount.
It should include text boxes for revenue where a user enters reveue for a

I have a Access 2002 database with reports.
I am forming a query dynamically in my VB front end with 'where' condition,
and opening an access report using Docmd.openreport command.
For example:Acc.DoCmd.OpenReport "AllAssociationsOfAPersonAsOnDate",

i am totally new at reports and I'd like help with this question.  
I use two unbound combo boxes on my form (cbxSession) and cbxDay) to select
matching records from the underlying query. (works great)  Now I have added a
Print button with the following code:

I re-designed a from for a registration program in access. I did this on
another computer with a copy of the database. How do I transfer the new forms
to the database in my other computer?