The Dcount work fine when gettnig the info from one table. But how do I get Dcount to work with tables that are linked by relationship? I used access anayze table and now I have 5 tables for 700 personel.
"TABLES NAME" [FIELDS]
1. Miplers Name, age, DOB, etc
2. Recall Address, PH #, Pger, cell
3. UIC Either 2253 or 1190
4. Rank/Remarks E1-E9, Enlisted or O1-06 Officers
5. Education/Training Courses,College, Tech schoo1, etc.
some of the things I need to count in my Report:
1. # officers at 1190
2. # officers at 2253
3. # of total Enlisted that has college
4. # of Enlisted at 2253 with college only
Use using Dcount I kept getting an #ERROR. Dcount works fine but not when it comes to using inforamtion in a lookup tables...
=DCount("[uic]","lookup to uic tbl","[uic]='32253' "
will not work. I should have 100% of my probles solved...
FOR NOW!!! THANKS...
"TABLES NAME" [FIELDS]
1. Miplers Name, age, DOB, etc
2. Recall Address, PH #, Pger, cell
3. UIC Either 2253 or 1190
4. Rank/Remarks E1-E9, Enlisted or O1-06 Officers
5. Education/Training Courses,College, Tech schoo1, etc.
some of the things I need to count in my Report:
1. # officers at 1190
2. # officers at 2253
3. # of total Enlisted that has college
4. # of Enlisted at 2253 with college only
Use using Dcount I kept getting an #ERROR. Dcount works fine but not when it comes to using inforamtion in a lookup tables...
=DCount("[uic]","lookup to uic tbl","[uic]='32253' "
will not work. I should have 100% of my probles solved...
FOR NOW!!! THANKS...
