I'm wanting to insert a carriage return into a report text box that is a
concatentination of two different DB fields.  I've tried to set the following
as the data source for the text box:
="Description: " & [projDescription] & chr(13) & chr(13) & "Status: " &

I have seen printed reports where the field size on the report does
not have enough space to print the value in the field.  The first part
of the value in the field is printed and then an ellipis (...) is
inserted indicating that there is more but not enough room to print

I'm new to Microsoft Access and I'm trying to create a database in-house for
our brokerage firm.  The report consists of transactions done every day with
about 20 or so defined fields.  We currently have about 24K transactions from
last year in the database.  

I am trying to make a report design easier by concatenating 2 dates separated
by a hyphen rather than having 3 separate controls, but I cannot get the
times to display as hh:mm rather than hh:mm:ss even tho' singly they are
perfect.  If there is a way to set up the expression ...

I'm trying to set up an invoice with certain information printed only once.  
Since this information is carried on all the query records, how do I tell it
to do this.  The rest of it is summarized and will print out accordingly.
Thanks!

I have a report that lists totals (currency) and a field that notes the
difference between the two dates - is there a way to highlight (make red for
example) the fields that have a negative number?
Cheers

how do I get rid of #Num! displaying in an equation?

I have a graph in ACCESS from a query - I have a field month - set as Text
(Oct 06, Nov 06, etc). In my graph it changes to Oct 07...I have formatted
the field as text in the source box even and I can get the design view to
show correctly, but when I view the chart it still says ...

Does anyone know how to add a page label (a label on the right side of every
page). In MS Word, I can add the label (a picture) as part of footer, i.e. by
dragging the picture in textbox to the right side of the page but still part
of a footer.

I am trying to create an access report to print 1099-misc vendor tax reports
on laserjet forms, to replace the continous forms of the dot matrix printer
we have used up to now.
the form has 2 reports per page

Simple question:  How do I change the filter in the properties tab to do an
"or" filter:
PM_Name="Smith" OR Owner_Name="Smith"
how do I write the code or an or statement?

I have a database that tracks attendance in my computer lab.  Most of the
reports are pretty straight forward, but there is one person that needs (or
wants, actually) a report that prints in a calendar format.  
How can I accomplish this using an Access 2003 database?

I would like to generate a printable invoice based on job data in my
database.. basically, i have 3 tables.. Jobs, Customers and JobsPartsUsed
Relating to this problem, the tables have the following fields..
Jobs table

Here is my SQL statement
SELECT Sum([TIME WORKED].[HOURS WORKED]) AS [SumOfHOURS WORKED], [TIME
WORKED].DATE, [Employee list].NAME, [Employee list].[SHIFT/SQUAD]
FROM [Employee list] LEFT JOIN [TIME WORKED] ON [Employee list].ID =

Can I put in reports values in controls, like a textbox, from the form used
to summon the report? Thanks, Chay