How do you add a page break in a report?  I also need to change a name from
all upper to Upper and lower....is this possible?

I wonder how (assuming it's possible, using expression value) I can use
CONDITIONAL format so that it formats a specific field in my report if
another field has a specific value?
In my case I have invoice number, that I want to format, if a reminder has

Can anyone tell me if the latest version of Access allows rotated labels or
text fields? Be nice if they FINALLY did! (The MS knowledge base doesn't seem
to know.)

I have a report in Access 2007 that uses fields in a continuous form, one row
and 6 fields accross.  Because the length of data is the fields is
inconsistant, I turned on the "Can Grow" options for all fields in form.  The
problem is, if one field grows, the others do not and the ...

I am trying to complete an Access project and have created a database of two
tables - one of family and one of friends that I have to put into a one page
report.  Their are only 3 records in each table.  I have worked hours trying
to figure this out and have enlisted the help of ...

I dont seem to find the way how i can do this report which i really need .
I need to have a report that can print only 3 records , this i was able to
achieve but the issue is that i need the report to be able to print either 3
consecutive records where i specify the first record ...

I have a workorders database (2003) that also stores each customer's list of
loaned equipment. If the customer has not purchased product in the last 90
day's I want to display that customer and all of the equipment they have on
loan so that we can go and pick it up...

Hello -
I am getting an error with this formula:
=IIf(NZ(DLookUp([PymtTotal],"q_PymtTotalsBySessionSub","[FamilyID]=" &
[Family_ID])),0,(DLookUp([PymtTotal],"q_PymtTotalsBySessionSub","[FamilyID]="

I've checked out the prior messages regarding the error message that appears
when attempting to run a report (The expression is typed incorrectly, or is
too complicated to be evaluated......).
The query i based the report on runs fine.  The report, Land Record report,

My qery based report shows a list of students exam and their progress.
Each student has many exams taken with a date for each.
However I do not want all exams shown, only the last one (NewestDate)
At the moment, if I set the date to descending order in the query and show

how can i exoprt a report to a text file (office) with  all the format
(inculds lines and tables) and not only the database.

How can I retrieve the count of records of different names from a single
field with the DCount function?
I can retrieve from a field such as [ethnicity] the number of say, Irish
using in control source =DCount ("[Ethnicity]","qryX","[Ethnicity]='Irish'

I have a report with a memo field , the field can be 1 to many lines, how can
i get a horizontal line to print on the next line following the memo field.

I have a report where I need to pull month end numbers as well as the
previous month's numbers.
Here is what I am currently using for the month end:
Between DateSerial(Year(Date()), Month(Date())-1,1) AND

I have a report that pulls YTD reports. Since we are now going into a new
year I would like it to only report 2008 data what do I need to put in the
query to make it only pull the current year data?