I have a listing of birthdays in a database and I want to calculate
their age as of the current year regardless of what specific day/month
it is. I am using the following formula as found on http://allenbrowne.com/func-08.html:
=DateDiff("y","[DOB]",Date())

I have a report that shades the background of alternate rows of data.  I
tried to set a conditional format to change the text color when one of the
fields is <2.  The alternate row background shading vanished for that field,
regardless of what the conditional format causes the ...

I have created a report with drag and drop of 20 queries.
If there is a need to see more details that should be possible for the user
by running other and more detailed queries than the ones used in my report.
Therefore I would like to add "buttons" to this report to make it ...

I am running a report by entering parameter values, my problem is, that when
the report is generated it automaticaly sorts these numbers numericaly.  Is
there some way to have the report generated in the exact orededr I enter the
parameter values?

I have a fairly simple financial report based off a query. The query results
looks like this:
ID    Amount    PMethod        Description
1        50.00     Credit Card    Membership

I have a main report named A. Inside I have 3 subreports named 1; 2 and 3.
Each subreport as 3 columns.
I need that the values of subreport 3 are calculated from subreport 1 and 2.
So, my column 1 in Subreport 3 will be the difference between column 1 of

Guys,
Please help me on my below concern.
I have a report, this report is a one page report (for Product Labeling).
The report contain a field of "Serial Number"

How do I stop a Access report form showing no data when an incorrect record
ID # is entered into a parameter textbox on an input popup form?

I am using the following coding, could someone assist in format for currency?
Sum(Nz([PR $ Value])) AS [$ Value]
Thanks

I have used a form as a criteria to retrict the results of the SQL statement
used for my report.  It limits the date range
Between [Forms]![frm_Report Date Selection].[Start] And [Forms]![frm_Report
Date Selection].[End]

I am using the following expression, it is not totaling correct it shows up
as 370 and the correct value is 54,759,393
Here is the expression...
Sum(IIf([PR $ Value],1,0)) AS [$ Value]

My form and report that based on the table has many records. I would like
the old records deleted by themselves if their check out dates are pass the
current month.
Ex: check out date: 02/08/08.  It will be deleting by itself if today is

Is there anyway to round up to the next highest number using the following?
=Sum([daystoaward]/[awarddays])
Thanks

Could someone please assist with this?
I would like to count the y's in a complete field and then subtract it from
the awarddays field. Where assigned = Carla.
=Sum(IIf([complete]-[awarddays],1,0))

I keep getting the #Error in my text box.  What is wrong with this syntax?
=Nz(DLookUp("[Affiliation]","tblFaculty","[FacID] =" & [Outside]),"")