In an earlier thread I got some good advise on concatenating text
strings and line break characters: Chr(13) & Chr(10)
However, I cannot make this work if I have a text string in a database
field like for instance: "This is line 1 <br>This is line 2<br>This is

I'm sure this is simple but I'm missing it........
Hi
I have a subreport that is set to be invisible if it does not contain any
data. This had to be done because of another report that the sub is used on.

I have a table like this:
id         date           place
and i need a query like  this:
place   january  february   march   .........

I have created a report in access, I need to single space the group
information. can you help me. I've tried going into properties but there is
not any line spacing option.

Hello
I'm using a report to figure invoices to send to customers for billing.  I
have the data Grouped by Week and Customer.  I'm trying to figure out how to
get the report to put the Week dates (ie 10/17/05 thru 10/23/05) in a header

I have a report with 3 groups: group1, group2, and group3. I have a number
field placed on the detail section.
I want to sum up the number field and place the running total on each of the
groups, so that group1 will display the total of the detail section, group2

I have read in thie forum that you can change a line into dashes and the the
the font to Courier New. Could someone tell me how to do this. There are only
2 choices on the toolbar: / and a box,how do edited them to change to dashes
in the detail section of a report.?

We use a database agency wide to create reports that are distributed via
email. For many that run the report it appears in micro-font in the upper
left-hand corner of the page. Even when viewed normally it will export to
snapshot in that illegible format. How can that be ...

I have a report based upon payments received by customers.  If, for
instance, the invoice that the customer is paying has several line items on
it and they make several payments, my report lists the line items over and
over again as being paid.

My packing list is being folded so that the bottom part of the page is
used to display the address through a plastic document holder.
But how can I ensure that the footer is printed in the same position
measured from the bottom of the page when there is a variable number of

The report designed by Mr. Hookum 'rptShipRequiredDates' is almost
exactly what I have been trying to achieve for weeks. I spent quite
some time looking at it (and the underlying code today). I am not sure
how the table ttblWeekOf is populated. I see dates in the table - are

 Please help.
I have 7 values entered by user using a form.  I want to add those values
that are displayed as a total in a report.  Here is my code:
=sum(Nz([queryname]![value1],0)

I have a 2003 db with multiple tables that all refer to each other.  My
tblStoreData has fields like StoreNumber, StorePhone, StoreName, OwnerID,
RegionID, DistrictID that contain numerical values that correspond to data
in other tables like tblOwners which has OwnerID, OwnerName ...

I am running this application in Access 97 and need to show results using
this calculation:
=(IIf([rpt_Product_TequilaInfoData_Collection_PrevDay].[Report].[HasData],[rpt_Product_TequilaInfoData_Collection_PrevDay].[Report]![txt_ActualOnHndSales] ...

Hi group.
I have a MS Access table with fields
PersonID
AccountNo