I have 4 circuits that I record outages for in a single table.  Every week a
report is created that lists the activity for each circuit.  If there is no
outage, I want the report to say 'none' for the times of the outage, 0 for
the minutes out, 0 for the total  # of outages, and ...

I would like to calculate the age between two dates i.e Date of Birth and
today. I would like to display the age on my report. I am using Office 2003.
How do I go about it?

Dear Expert(s)
I have a Journal Report of my Vouchers based on query
[TotalDebit_Journal-Qry] in which , on any run, the report (underlying query)
asks for start and end of voucher no.

I want to do a two column report as such...
Date        Time        Credit        Debit
1/1/08    4:30                            $6.00
1/3/08    4:24           $2.00

i need to create a stacked bar chart in access 2003 that use a date parameter
query.

I've read everything here that I think might apply, but still can't make this
work.
I have a subreport in a section footer. In the subreport I have a text box
that I want to set to the value of a control in the section header on the

I have a report which shows responses to survey questions, grouped by survey
number.  What I would like to do is get the average response value for each
survey question.  The report would look something like this:
Survey #1

I've several of the posts pertaining to this and have tried the suggestions
posted but to none avail.
I have a database from Access 2000 that uses linked tables to a SQLServer
2000 machine.  The Access file sits in a shared folder on the same machine as

How are you guys doing? I have a question about using SELECT and MAX
function. Say I have a Students Table with Fields StudentID,
FirstName, MiddleName, Score
StudentID   FirstName  MiddleName Score

Is that possible that refer a report from a form?
I try to create a Search Form, there are some combo boxes on it to take the
input from a user; based on the multiple inputs, it will re-query the query
called qAll, then display the result on the report named ReportByStudents.

I have been given a database of Company names, addresses and associated
phone numbers.  They require a simple report sorted by Company , but in the
instance that 2 or more companies have the same phone number they want one
line of the recordset showing all company names ...

I have set up a report using the fields in my main database into an invoice
design, with the desire to have an invoice for each of my records however
each time i click on the command button from a records form page taking me to
the report, its only ever giving me the details of ...

I have enabled the "Can Grow" feature on some columns in a report. I also
have the border set to "hairline" on each field.
The reason I have borders is so I have a vertical line between the data in
each field.

I am trying to get my repeort to show Practice Name and if it is null to
print address 1.  what expression do I need to write to accomplish this.  
thanks Grace

I wold like to convert a .net front end time sheet application to Access
2007.  I currently have one table that tracks the records.  This application
is tied into anothe r table that populates a pull down menu for people to
select a particular project. A strong reporting function ...