I have a report, based on a query that extracts data from just one table.  
The query captures an ID field, LName, FName, and several other fields.
If there are separate entries for Smith, John and Smith, Mary I get one
report entry for Smith, John and no report for Smith, Mary.  I ...

Is it possible to create/edit a report without having exclusive access? If
so, how?  I can't figure it out.

I would like to print my full access data base information
Can someone help me to do that
thanks
clearly I am not too sure what I am doing

How do I set a value of a  text box on a report??
In the reports  report_open event I have txt_month.value = str_month
str_month is public from another form
error is: you can't assign a value to this object.

I create a crosstab query and use it as my report recordsource. Because I
can not predict which column (return from query) will be exist, So I think I
will create enough unbound text boxes in report to display return columns.
Afer try, I found problem that I can not refer to those ...

I am calculating mileage. I need to subtract the lowest value from the
highest value out of several values in a group to get the miles driven.

Can anyone tell if it is possible to binds a textbox on a
report to show the value of a single record in a table?
If it is possible, please tell me.
Thanks

i made a costum report of many controls in the detail section and it fits
five records max based on a query, my problem is if there is less than five
records then it leaves the remaining sheet  blank, i want to be able to have
five records on a sheet even if there is no data in ...

I'm attempting to preface each page number with a unique ID.  The format needs to be as follows:
KeyID_0000001,KeyID_0000002,KeyID_0000003 etc...
It must always contain 13 characters and must be sequetial.  I'm having difficulties prefacing the numbers with the preceeding zero's.

I am using Office XP Pro 2002 and I need some help on a report.
I want to print the report based on one Test# or 2 Test#'s. I can get it to
print the one Test# but when I enter the second Test# it prints all Test#'s.
This is the code I have written:

I have the following report set up.
Page Header information
Page Detail
Page Footer.

Im writing a report in Access 2003 and would like to hide the detail when
there's no data in it.  And if possible, I would like to reduce the height
of the header just above it.  Is any of this possible and if so, how?
Thanks.

I installed Windows XP SP2 about a week ago and today I
noticed that Access 2002 is very slow when trying to view
a design of a report.
Office XP Pro: Access 202 ver 10.6501.6714  (SP3)

I have created an expresssion in a query that converts hours and minutes to
decimal times.  I would like to add the total decimal times for a month in my
report but I keep getting a message that the expression is too complex.  I
have tried using the "sum" operator in the query ...

I hope you can help me with a query and report in which I am getting a wrong
sub-total on Total Sales..  The report is using the following field-
=sum([Total_Sales])  in the group footer and getting the wrong answer  while
[Total_Sales] in the detail is correct .