Need help in Dates Calculations.

[Guest]

Hello every Body.

I have a DB in which i want that it will show me the report by taking a
Parameter through keyboard and the Parameter value should be Date. It will
take the date and filter all the records of the concern date. how would be it
possible?

Can any one help please...?

the second thing is that when i give the date of birth in the DOB Field and
Current Date in the Present Date Field it whould display the Difference in
years between the two dates. But how.?

urgent help needed please.

Regards,

Khaksar.

 

[Allen Browne]

See:
http://allenbrowne.com/func-08.html

The article explains some common solutions that don't work, and illustrates
how to get the correct number of years. The 2nd argument will be your
Present Date Field.

 

[Guest]

Yes Allen thanks for the help. I got the solution on some other way. But now
the age appears in the form. but not appers in the main table and Report is
also based on main table so in report it also does not come.

Can you give some idea please.?

Regards.

 

[Douglas J. Steele]

Since it's constantly changing, the Age should not be stored in the table:
you should calculate it in a query, and use the query as the ReocrdSource of
the report.

 

[Allen Browne]

Doug is right: it is really important not to put this Age field in your
table.

Here's more information about how to do it in the query:
Calculated Fields
at:
http://allenbrowne.com/casu-14.html

 

[Guest]

Thanks to both you for the help. I did the same I made a query and it shows
the age. But not in main table , Report or Form. When I run the query it
display the results in its own cretaed table. So now can you please tell me
the way that how can i migrate the AGE value to the report and my main table
please ?

Regards,

Khaksar.

 

[Allen Browne]

1. Open the report in design view.

2. Open the Properties box.

3. Looking at the properties of the report (not of a text box), change the
RecordSource property (first item on the Data tab) to the name of the query
instead of the name of the report.

You can now use the calculated field in your report.

As I said previously, you can use the query with the calculated field
anywhere you used your table.

 

[Guest]

Yes I did the Same as you quoted. But I it asks then for the Parameters.
because teh properties of the Age Calculation query implemnts on the all
Report fields.

the second thing is that I have designed a query for age calculation It is
also giving correct values but now how to bring its values in the age field
of the Table of Report I don not know that...??

Please proceed ur kind help..

Thanks.

 

[Allen Browne]

If Access asks for a parameter, it means it cannot find the field of that
name in the source table/query. This would indicate you have not
successfully changed the Record Source property of the report - either that,
or you are not spelling the field the same way.

Once the report is based on the *query*, not the table, your question of how
to put the field in the report's table disappears, since the report is based
on the query instead of the table.