I have a text box in the detail section of a report and I would like to sort
by the LastName part of the expression.  
=[FIRSTNAME] & " " & [LASTNAME] & " " & [Degree]
Thanks in advance for any help.

When i originally designed my report, it was 4 pages. Now I have modified all
the info to fit onto two pages, but it won't let me get rid of the two that
used to contain information and are now blank! It just prints blank pages!
Help!

Many moons ago in an older version of Access I created a database to
administer various aspects of home life, including a facility to print
address labels for everyone who is marked as eligible for a Christmas card -
so that function only gets used once a year.

Here's the deal -
I have a report (based on a query). I've created several fields in the
report, only to be populated based on a certain criterion. I am then
attempting to SUM those created fields. But the Jet engine refuses to

I am working on a database for sales leads.  I have two tables which hold
dfferent type leads (Dealers & Homeowners), I already have several queries
set for each to select leads for each territory by state and to count leads
for each of our sales territories. What I need to be ...

How should I format a memo field with hanging indent in report or form?
Please help me.
Thanks
Phang

Hi Folks,
I have analyzing some data in a electric utility database
I have created.  Each record in the database represents a
resident's utulity bill in both tkw(total kilowats) and

I have a query than when I run it show 6 records.  When I attached the same
query to a report, the report only shows one record.  Any ideas why this may
be happening?

I have a table with personal client information.  One field shows date of
birth;  the next field has a calculated expression showing the person's age:
=(Date()-[DateOfBirth])/365.
My problem is, the result is displayed to 7 decimal places.  How do I format

Is anyone able to help me with this.  I have posted it to Access.Forms and
.Formscoding but go one response at all.  Know this may not be the right user
group but I know that I always get help from this group and don't seem to be
with the others.  Any help gratefully accepted.

I created a report using the wizard, selected the query I wanted to use for
population of the report.
I have an unbound textbox on a form where the user enters a "code".  I need
to print this code on each page of the report.  But I can't figure out how

My query runs fine and shows 6 records.  When I link it to a report the
report only shows 1 records.  Any ideas????
Thanks in advance

I am creating a report based on form criteria. And on the form I have few
fields like combo boxes, checkboxes..etc. Now I want the records to appear in
my report which would be the combination of criteria..like
one combobox is: job location

Everytime I try to create a new report in Microsoft Access I get the message:
"There was a problem retrieving printer information for this object. The
object may have been sent to a printer that is unavailable." I'm only trying
to create a report, not print anything.  I don't ...

How can I get a paramter from a dialog box to displaly in an unbound text box
in the header of my report?  I have typed in the Query's criteria that refers
to the dialog form and the report gives the correct results but I get "Name"
in the unbound text boxes.