How would I be able to calculate the current age of a person based on a
birthdate field (Short Date 99/99/0000;0;_) Basically, I want a report that
has name and age.
Many thanks for any assistance.

I used the calender report from invisibile inc awhile back and forgot the
answer to a smiliar question I had about this report before.  I have a report
with a subreport and am returning 4 records for a given week because I have 4
"doctors" seeing "patients".  I want to combine ...

I have a report that is pulled by a date range (entered in a form), and this
date range is referenced in the report to show the Quarter that is being
pulled.  Unfortunately, it is on a calendar year and we are on a fiscal year,
with our fiscal year running from Oct 1 through Sept ...

Got some problems here, initially i got a database where there is a field
call "GENDER" i make it as a combo box in form where the values is "F" and
"M" only, when i wan to display and print out in a report format, i cant
display as an option, because i need to printout the ...

I am a newbie. I need to produce a report where weekly
amounts of sales are shown(ie. 52 columns, starting
1/4/04). All dates of sale are in a single field in my
table. I have 34 different sales branches. Could somebody

I have created a QBF to start a 'make table query'.  This data in the make
table query is then put through a 'cross tab query' and finally into a
calander type report.  i am wanting to show on the report the query
parameters selected at the QBF stage.  I thought I should be able ...

I posted a couple times over the past few weeks, but have
yet to get any assistance on this.  If someone could
provide some light on this I would surely appreciate it.  
I have a report that has a union query as it's source.  

I have a field on my main report called InvoiceTotal and a field on a
subreport called DepositTotal. I have created a field on the main report
called InvoiceBalance where InvoiceBalance = InvoiceTotal - DepositTotal (on
the subreport). Question is: how do I reference the field in ...

I have a two-column report that ends in the middle of the
second (right-hand) column, but the totals for the report
are not displayed until the first column of the next
page. What can I do to fix this?

I have a text box I have populated with a string. The string calls out to
some sub reports. It looks good but when a particular record has multiple
values linked in the sub reports it only displays the first record from
them. Here is an example of my code:

Thanks to Duane for his elegant Concatenate function.
One of the Concatenates I'm using involves differing
datatypes.  The source table is 3 fields: ID, Date (MDY),
and Occasion (string).  Using the suggested SQL construct

I have a graph in a report based on a query with a
parameter value. I am prompted to enter the parameter
value when the report starts and then once for every page
it formats.  If I take the graph off, it works normally.  

I have a report, based on a query which I have grouped on a field called
"source"
So each record with source = "Distributer" is displayed, followed by totals.
Then each record with source = "Vendor" is displayed followed by totals

I have a Report that has a subreport.  I've been applying
a filter to the report. The filter I've been using is
saved as a Query. However, I've come to the conclusion
that I would have more accurate reports if I could apply

I have a report that is emailed out as an acknowledgment.  It contains a
pair of '&&' in the company name as in 'Johnson && Johnson'.  It displays
fine in Access ('97) as 'Johnson & Johnson' but the emailed report shows the
double ampersand in the word document.