I have a payrol report that calculates the time worked and the amount earned
for each record
the time worked is: =[time finish]-[time start]
the amount earned is: =((Hour([total hours])*60+Minute([total

I have a report with a group on "team name" and "person".  I have a header
and footer set up for each, so I get a total of hours worked for each person,
and a total of hours worked for each team.
I would like to create a "cover sheet summary" in the report header section

Hello All, I am in the process of making an awards database for my company. I
need to create reports for the Fiscal Year(Oct-Sept) and Quarterly Reports. I
have the employees name, Supervisors Name, Recommender's Name, the Awards
Name and the Award Amount. I also have when the ...

Is anybody know how to automate zoom+ (big) when we make print preview in
Access?. Everytime I make a report, I always print preview first before I
print the report to printer. But the problem is, access always zoom- on print
preview. So we have to do 1 click tomake it bigger. For ...

I'm trying to create a report made up of about 10 subreports. Creating the
report isn't a problem but I want the subreports to show the control labels
even if there isn't any data (similar to a form) I've tried various formats
but can't get it to work. Anyone any idea how I can ...

Is there a way to remove the "SumOfFieldName" and just have the name of the
field? Please Assist with this.

I have query with two date fields: StartDate and EndDate, filter form with
two unbound text boxes, StartDate and EndDate, and report sorted on
StartDate, group on Month, Keep Together: Whole Group.
What I am trying to do is to get a total # of students grouped by sex:

Inserting a date using the following formula (as a text box) to the report
(defaults to report header for placement):
=Format(Date(),"Short Date")
Results in this output on the report:

I'm trying to create an invoice that will print double-sided.  On the front
of each page is printed the actual invoice info, while on the back of each
page I need to repeat the sales contract clauses.  Is there any way to do
this in Access?

Hi again
(The day I am skillful enough to actually answer some of these questions!)
I've been trying to sort a report by postcode, however access sorts them like
this: LE1, LE11, LE13, LE2, instead of like this: LE1, LE2, LE11, LE13, and

Marshall Barton replied to my previous post, with code as below, to create a
'roundy rectangle'
And all worked well. Or so I thought.
The report looked fine on screen, and printed fine. However, if coverted to

hi  all & thanks for you your help.
I have the following SQL query & I am trying to create a report using
the dcount statement listed below the 1st SQL statement, but I am
getting errors.please look at the Dcount statement and tell me where I

I have a form where staff can go and add student information, I would like to
be able to capture when and if the form has been modified.  We are running
reports on students with certain behaviours right now but we don't know how
up-to-date the data is if we don't capture if it's ...

I am trying to create a report based on 30 queries . These 30 queries
are based on one table. When I use the Report wizard and select more
than one query I get the message " You have chosen fields from record
source which the wizard can't connect. You may have chosen fields from

I need to create reports that compare our current fiscal year activity for
the current month with the previous year same month. I have tried creating a
table for the previous year information and a query for the current year but
that gives the same information for every month. ...