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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

forumla for finding missing number

Status
Not open for further replies.

pinkpoppy

Programmer
Jul 6, 2011
75
US
I am doing a survey of a group of people for a special demographic research.
I need to find what age is missing from this group. I need to display from 2 different tables: Table1 has the "RACE" field and Table2 has the "Age" field.

For example, my report current display as follows for year 2013.

Code:
White
17
18
20
21

Black
18
19
22
25


Asian
20
21
22
23


Prefer Not to Answer
20
21
23
24

I have 2 parameter field which have values ranging from ages 18-30 and year 2012 -2014.
I need a forumal that will display the group of people who's age I have not researched. I need a formula that will include the 2 parameters {?Month} and {?Year}

Need Example data:

Code:
White
17
18
20
21


Asian
20
21
22
23


Prefer Not to Answer
20
21
23
24

Parameter searching for: age 19 and year 2013
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top