i have created a small address book in ms access. using parameter
query i'm able to get the required address and able to print..
But i have sometimes 10 or more for that i have created a query as
In(2,7,9,11) like that to extract the records each and every time..

Hi! I've been working on this for a long time, but I can't figure it out and
I learnt access by trial and error so if anyone can help me out I would
appreciate it.
I have a table with the followin:

Let me see if I can explain the structure before the question ...
The table named TblLeads uses two fields, LeadsBy & AssignedTo, which are
List Box lookups from the table named TblEmployees.
TblEmployees is simple in that it contains a primary key (set to autonumber)

Using Access 2007, I output a report to a singe PDF file that consists of
invoices grouped by company. i would like to create a seperate PDF for each
company. Some companies invoice data consists of multiple pages. I am
attempting to do this using the OutPutTo command. I need ...

I have a multi page report which includes a field to calculate the
[Qty]*[Rate].  I would like to have a sum shown at the bottom of each page
and a grand total at the end of the report.  Can anyone suggest how to sum
the [ExtendedCost] at the end of each page?

I use the following code to export a report to a pdf file :
  ' Open report as hidden
  DoCmd.OpenReport p_NomEtat, acViewPreview, , p_CondtionWhere, acHidden
  ' Print toPDF

My output report is:
WO#     Inspection Type     Number of Faults
1199      Pre Final               15
1199      Final                     23

Hi.  I have a contract report in my database, showing contract amount, change
orders, paid to date, remaining balance and percent complete.  For some
contracts, the vendor works on more than one project ID.  I have the report
set up to group by project ID and everything works ...

Ok, I'm starting to wonder if I'm trying to do something that isn't doable,
or if the manner in which I am trying to do it is completely wrong.  I'll try
to explain as clearly as possible.
Our business is making loans to borrowers secured against their investment

My report uses a query which concatenates 2 fields:
concatenatedField: [field1] & " (" & [field2] & ")"
sort: Ascending
(the query contains other fields without sorting)

I use an Access DB to maintain "review of documents". Each must be
reviewed every 3yrs.
I have 2 tables, one is a distribution list, the other a document
list. The relationship is the "short name" of who is responsible for

In a report, I want a particular control to be visible only when the value is
more than zero.  I used the conditional formatting for the control and set it
to the expression:
IIf([Reg]>0,[Reg],"") but it doesn't work.  I tried doing it without the IIf

I am unable to change margins on a report designed to print labels.  I
change them, but Access ignores the change.
Background:
I have an Access database (Access 2007 fully patched) that I have been

I have a report that is based on a government form that has several vertical
lines.  One of the lines in the report needs to be pegged to a horizontal
line and to grow downward if information in one of the fields on either side
of the line increases by more than four lines.  The ...

When the form first opens all the labels look perfect, but as soon as I
scroll through records using a command button suddenly a few of the labels
start to take on a bold appearance.
The issue occurs with a same labels very time. I can't figure out what’s