Greetings,

I have created a database to track applicants’ eligibility process. So far, the database works fine and just recently, I was approached to add a new field (source of Application) where applicants learn about our program (Friend, School, Doctor, Advertisement, other etc.)
I'm not sure if this is the right way to do it, but I've created a lookup table 'tblAppSource' w/ list of options (Friend, School, Doctor...)also added a field called AppSource in one of my table and join them in table level.
I’m using access 2003, and given the type of report I need to generate (Source of Application)how do I go about creating the query so I can pull in my report how many were referred by Friend, by Family, by School etc.

Thank you in advance,

OCM

if you have created a relationship between the applicant table the appsource table.

start a new query
add your to table (applicant, appsource)
in the grid add the columns from applicants you want to see and then the columns from appsource, make sure to include the column that stores your source description

follow this example from sample northwind database

SELECT Categories.CategoryName, Products.ProductName, Products.QuantityPerUnit, Products.UnitsInStock, Products.Discontinued
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID
WHERE (((Products.Discontinued)<>Yes))
ORDER BY Categories.CategoryName, Products.ProductName;

Note:

Avoid using a lookup table from your applicant table

create a separate table
[u]tbl_appsource</u>
appsourceID
appsource_desc

In your entry form create the combo box the user will use to select the referral type.