Good day,  can someone help me out.  I need a very simple solution.  How do I
print multiple records from one Print command button.  My Quality Specialist
create audit forms some up to 50 records. There is a print command button
that is attached to the report that has mirrors the ...

I'm having trouble with the following setup. I've been tasked with creating
an Access DB with a report which will use graphic symbols for different
status conditions, (ie. green up arrow to indicate positive progress, red
down arrow to indicate negative progress, yellow double ...

I am creating some reports, and I'd like to concatenate fields. Some of the
fields have the same name as fields from other tables used for the report,
therefore I'd like to use the format tblName.fieldName (as opposed to just
fieldName).

How are you all doing? I have the following CrossTab query working
fine with Date Range passing from a Form. Looking at the 2 Tables
below, on some Date Range, they might have have all Jobs from AA - GG.
But sometimes, it might not have the whole listing (Report 2 - no FF &

The field of DateType of the following crosstab Query, will show the field
name on the report,
TRANSFORM Count(FrankS.TheDate) AS CountOfTheDate
SELECT Replace([DateType],"Date","Number") AS Activity,

I would like to know how I can get the contents of a text box from a report,
and fire a msgbox with that result.
The report is called rep_winst per maand (so spaces included), the name of
the text box is Sum Of winstbetaald (spaces included).

I have a report that displays information about IT Projects. The report
includes 46 fields for each project and shows where required information is
missing. What I want to do is to display a count of the number of "missing
info" fields for each project.

I'm creating a report in which I need only specific information for it. Right
now I have a list of countries and the students that applied from those
countries. I want to have a summary breakdown in the report like this:
USA = A

I accidentally deleted the wrong report.  I have not closed the db, is there
a way to restore it?
QB

I have a report that i'm trying to run.  i have criteria set up so that when
you run the report you choose what region (geographic) you want to see.  I
have four regions to choose from.  I can successfully run the first three
regions and export to Rich text word documents with no ...

Although this group is very helpful, there are sometimes problems I
have that are too complex (to me!) to describe. Are there any Access
companies/individuals out there who offer paid support by email or
telephone - people who would physically look at my database and then

I have three tables I'm trying to query.
Table 1 - Employees
Table 2 - Cell Phones
Table 3 - Pagers

I am trying to gather statistics for my job. I know I can creat a query that
I can filter information out of, but I would like to have the report do that
if possible, that way I can cut down on the total number of queries I have.
Basically I want to calculate the average test ...