I have a Report that I would like to have only one Record per page. At this
time I have the Sorting Grouping Keep Together set to Whole Group. It works
ok if each record has data that will fill more that half the page. But I do
have some that will fit in just under the record ...

Is it possible to find the value of a field in the previous record entered?
I have a database which I update, but the value of one field is dependant on
the previous record.
So if Field 1 of Record1 is 7, then Field 1 of the next record could be 8 or

I have a report in access. I used the "trim" function to concatenate text and
some field names. Some fields are in format of number with decimals. I want
those fields shown formatted on the report, but I need a function to format
such field within the concatenation. Can somebody ...

My database has a field for "Dept Number".  Then, there are fields for
entries for employees who are either Active or Terminated.  I want the report
to Show the Dept Number once, and then show the sum of either the Active or
Terminated employess.

How can I create a 2 column report with 2 headers always at the top and the
detail section to be 2 columns
For example
-----------------------------------------------------------------------------------

I have a database which has a list of products and prices in one table. I
have another table which is updated each day from a file of new sales. If a
new product is sold which is not in my pricing table then I don't report
correctly. What I need is a query which will tell me ...

I have a form with an Update Status field. Each time the user clicks Update
Status, it enters the time and date in a comment field and they can type in
their comments. It is continous and may be as many as 50 entries for one
record in that one field. On my report when I ad that ...

I need to limit the contents of a report so I first created a button and then
used the code in: http://allenbrowne.com/casu-15.html.
However, when I got an error message that read
Run-time error '2455':

I am looking for a way to have a report include a group header (i.e. A.
apearing above all of the content that begins with the letter A). Do I need
to add a column to the table and put the Letter in it that I want to group by
or is there some way to generate this? this table has ...

I have a Access 2000 database that we are opening with 2003. If I log in (I
have admin rights) I can open the reports. If the end user logs in, he cannot
open any reports, even after I gave the user admin rights on the computer. I
am stumped here, Help

I have a budget report based on a crosstab query.  My column headings are
funds and my rows are budget amounts of accounts.  I prints
No.         100       200     300      400
12900     $100               $100    

I have a report with a query that concatenates:
1Address: [Address] & " " & [City] & " " & [StateOrProvince] & " " &
[PostalCode] & " " & [CountryRegion]
[Address] is a memo field and whenever a record contains a carriage return

I need to have a monthly report based on a time sheet that looks like this:
Month - Jan 05
-----------------
Proj No. Proj Name Proj Dtls       -------------  no. of hours

I would like to take a pre-printed special form, scan this into a file, load
this file into a report format, then plug access data into specific field
areas in multiple areas of the form.  Like using a flashed form overlay for
report layouts.  Is there a way to do that with ...

I have a nested running sum.  Basically it is the third grouping in the report
grouping #1 Date of visit  (group by month)
grouping #2 referring provider header  (group by value)
grouping #3 chart # header (group by value)