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 IamaSherpa 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. sicvic

    Display the count of a subset of ages in database

    Thanks for the Guide - that was awesome For others who may be have been following this post: Lets us says you recorded all ages of the kids in your neighbourhood. In your database you want to count how many kids are ages <1 This is my setup you will need two tables Table 1: Each record...
  2. sicvic

    Display the count of a subset of ages in database

    How would I go about the self join Create another table - Count and what fields do I create and to what Fields in the main table do I set a relationship?
  3. sicvic

    Display the count of a subset of ages in database

    Appreciate the response I tried the calculations Define Age 1 = Case(Yearfield < 1;1;0) Display count Age 1 = Count (Yearfield) I thought this calculation should give me a total of the ages <1 in the "Display count Age 1" field. However, it only flags that the records with 1 or 0. What is...
  4. sicvic

    Display the count of a subset of ages in database

    Hi I have a simple question. I have setup a research database that has ages of kids (Field name, "Age") within an age bracket (from 0 to 6). On my analysis layout page, A data point I am interested in displaying is a count of the number of kids with ages < 1 I have looked at other post...

Part and Inventory Search

Back
Top