I have a "yes/no" field called Sold.  I need to track and report what percent
of total solicitations sold.  I thought I could use the built in sum feature
which provides a record "Count(*)" for each record in a group.  However, I
dont know how to set up the equation as the ...

I have a report bound to a query, but when I attempt to add a grouping level,
all the fields in the query are not listed in the combo box. Any ideas?
(Using Access 2007)

I have a report with grouping based on RepName and it displays each reps
totals in [TxtTotals].
On that report I have another text box [TxtRate] with
=DLookUp("CommRate","TblCommissionRates",[TxtTotal] & " Between

I have a location table with four locations, I've setup a report to print by
location, the code do a loop through the location table and prints a separate
for each location.  When I set it up to do a preview instead of printing I
only get the first report  Here's the code I'm ...

I inserted a banner on top of my report which displays well on the first page
but for some reason it shrinks to the left hand corner of the following
pages. How do i get the banner picture to maintain it size so each page
displays it like the first?

I have two tables.  Table one is a customer table with general information.  
Table 2 have activity relating to the customer in table 1.  For examples lets
say your tracking purchases for a customer and table 2 is housing that
information.

I have a daily sales report which is built from a query pulling from 5
tables.  I built a report based on the query and am only grouping on the
"payment date" field from one of the tables.  Here is my
problem...........when I run either the query or the report.........some of

I have a multi page report with each employees time on a separate page.  I
want to email the employee's corresponding page to them.  I have their email
address in the database.  Can someone point me in the right direction?   I
have checked I can send from the report.  I just need ...

I am using forms to create customer invoices.
I would like to use the Lookup function in a text box to automatically fill
in a field on the form for each customer.
The "Invoices Query" query, on which the invoices form is based, contains a

I want to set up a report that will show the first week that a customer
ordered a product and the lastest week they ordered it.  That dates on the
report I receive are set up like the examples below:
12/30/2007 - 01/05/2008

Good Afternoon,
I'm really new at Microsoft Access, so I'm using a super basic contact
database template to store contact information for sales leads for my
business. All I need is a report that will pull from three tables:

I have only one of several reports that will not open either in view or
design view. All the others are ok.
The error message reads, "There isn't enough memory to perform this
operation. Close unneeded programs and try again..." My Vista computer has 3

I need to insert a particular photo (OLE object) with a particular item in a
report.  I have attached the photo in the form correctly, but cannot figure
out how to get it on the report.  Help!

Good Morning,
I have created a report with multiple columns.  Each Group has a total count
and summary in the Group Footer.  Can someone tell me how I can show this
total on the same line of the printed report (as each column contains

I need to create several reports that are exactly the same but get info from
different queries.  I can do this with no problem ... just change the source
for the report ... but the copied report still shows the original report name
in the tab when opened.  How do I get it to ...