I am creating a report that reflects Mortgage Lenders and Loan Volumes by
State.  In the table, I have 1 column for 1st Mtg Lender and another column
for 2nd Mtg Lender.  I have a separate entry in the form for each.  But on
the Report I want it to list the lender alphabetically ...

I want the report to give me a sum of the proposal amounts for those records
that have been checked off as awarded (I have the awarded field as a Yes/No).
I have a text box already created that counts the number of awarded
contracts. What I'd like is another text box to give me ...

I have a series of reports I run monthly,  around the first of every month...
I want to set it so that when the report is selected, a small form opens
asking for the month the report is needed for..... Even if it could just
prompt for the date range that would work... Thought I ...

Is it possible to print labels vertically (or at an angle), similar to
Excel?

I prepared a report in ms access . One of the field contains 108 values , so
i need to fit around 30 values in one page, what format i use ,and how, where
?, is it in design view?
Thanks and Regards

HI
i want to retrieve Blob image store in MS access Table
help ,me

I've got a report that I'm working on that groups on 5 fields.  Four of those
fields have a footer section with calculations (sums and a couple
percentages).  Now, when I try to run the report, I get a msgbox popping up
that says "No Current Record."  I click OK and another pops ...

I have a report which is created via VBA. I would like to change the
color of the controls depedning upon where in the VBA they are created.
Dim HealthInfo(0 To 5) As Control
Set HealthInfo(k) = CreateReportControl(OassisSummaryRpt.Name, acLabel,

I have two Yes/No fields, one for Contract Awarded and one for Contract Lost.
When I run a report I would like a count of each field. That way I know how
many proposals are still outstanding (based on how many have been sent) and
can use that info to calculate award percentages ...

Sorry if I am in the wrong forum but I need direction on this one report.
I have a need to automaticallu enter data on  regular basis. Every month an
employee earns sick and vacation time. I need that to be listed in the table
thus the report. I have too many employees to do that ...

I have designed a report with a Page and Group Header which are the same.  It
works fine, except the Heading appears twice under each other on the first
page, for obvious reasons.  Is there any way I can prevent this heading
appearing twice?

I have a query that I would like to use the criteria to select the records
returned, however I would like the criteria to select record 1 from a table
to retrieve the value of the criteria. Will this work? What is the syntax, if
the table is [Criteria] and the field is [GetValue] ...

I have report based on a table and a form. The Form's Data Entry property is
set to "Yes" and the Report's Record Source is a query based on the table
linked by the primary key inputted by the user on the form. The report
essence picks up the newly appended record only.

I am not sure how to do this but would like to display a field in a report
beside the records that will be coming due within five minutes of the current
time.  I have the report refreshing every 60 seconds.  I was trying to place
something into the Control Source of a TextBox ...

I have a report grouped by ID with several fields in the detail
section. For each group header I need to provide a count of distinct
records for that group. So for example:
********Group Header*************