Microsoft Access questions?

Question

I use a MS Access database to keep track of my personal and business contacts. Each entry has the person's date of birth, date of marriage, and names and dates of birth of their children. I have two questions which I would appreciate any help with: Firstly, I know how to use a calculated field to work out a person's age from their date of birth, but can anyone tell me how produce a report listing birthdays in order - i.e. using the date of birth, but ignoring the year of birth? Secondly, as each record holds a number of important dates, is there any way that I can produce a report which takes more than one date from each record to combine into one list of dates? I hope I have explained this fairly clearly. Any advice appreciated.

Answer 1

Since you know how to use a calculated field, the function you want for the first part is DatePart("y", DateField). This function (used with the "y" argumnent) will return the day of the year. You can then sort on this field for your query or report. If I understand your second question correctly, you just pull all the date fields you want in your query, then add them to the report for each record.

Answer 2

For the first question, create a new calculated field using Day and Month of the birthday but using a fixed Year (e.g. 1900). Then you can sort on this field (but not, of course, show it in the report).

The second question (if I understand you to mean you want a list grouped by date which shows events that occur on that date) requires that you use more than one related table to do what you want. Specifically, a Dates table with fields something like:

Date, ContactID, DateInfo (where DateInfo would hold information like Date of Birth, Date of Marriage, ChildDOB and so on). The DateInfo may, itself, need to be another table with 1-M relationships to the Contacts and the Date tables.

Answer 3

Yes it's possible. You can incorporate some VBA code into your access queries, but without me being able to see your table structure I can't suggest much more - except to say a previous respondent's answer was incorrect, unless you defined date as a string (you'd also have issues with date formatting).

Answer 4

It relies upon on the nature of your application. once you've faith in elements put in as area of workplace being modern-day, then your consumers will opt to purchase workplace. in case you count number in common words on the compiled executable you wrote, you're loose to promote that. i'd verify the licensing contract for seen uncomplicated convey; it used to state it replaced into for non-comercial use in common words. If that retains to be real you could opt to improve to an finished version of seen uncomplicated as a thanks to make commercial use of the application you strengthen.

Answer 5

You can search using the wildcard character - this is usually a percent sign (%).

So you can search on DOB like:
02/02/%