I need to produce a report from my database that outputs in the following form:
Total Records
212
Under 50 37.26%
79
Over 50 62.74%
133
Age Range
21 to 29 0.47%
1
30 to 39 13.68%
29
40 to 49 23.11%
49
50 to 59 37.74%
80
60 to 69 21.70%
46
70 to 79 3.30%
7
I have a query that gives me an...
Thank you EasyTarget and scriverb. Your tips worked beautifully and my report is now sorted by month and I was able to get the birthdays to display in chronological sequence. Now if I could ask your help in refining the report so that it displays the month in a header? For example.
January
Bob...
Thank you for your reply. The method you describe is actually what I have done but the year of birth is not ignored and all months within 1950 are sorted and then 1951,etc. I need all dates sorted, regardless of the year, by the month.
I need to create a report that groups records by birthday but ignores the year of birth. My records use the short date format 00/00/00. The purpose of the report is to have someone send birthday cards throughout the year easily. I can get around in Access but I am not knowledgeable about visual...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.