Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Pineland

    Demographics grouped with percentages in a Report

    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...
  2. Pineland

    Need to create a report that list birthdays by the month

    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...
  3. Pineland

    Need to create a report that list birthdays by the month

    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.
  4. Pineland

    Need to create a report that list birthdays 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...

Part and Inventory Search

Back
Top