Crazy Question

[Tejanorey]

Hi, I need some help. I have a database where I will need to base two reports off of. One is the complete list of information that is typed in on the form and the other is the information to personnel that is "absent" from the organization I work for. Is there a way where I can leave a field blank and the individual record will go to the "Missing Files Report" vice the "Complete Report" or is there like a "check box" where I can click and that will in then move the record to the "Missing Files Report". Can somebody please help me? And if possible to email me an example to Tejanorey@hotmail.com or devildog112@excite.com. I would dearly appreciate any responses that would lead to this type of solution. Thank you again.

Tejanorey

"Do not attack the First Marine Division. Leave the yellowlegs alone. Strike the American Army."
- Orders given to Communist troops in the Korean War; shortly afterward, the Marines were ordered to not wear their khaki leggings to keep the enemy from immediately fleeing

 

[JeremyNYC]

TejanoRey,

Well, this is a public forum, and the idea is that all answers get posted on the forum, so that everyone can learn from it.

Look into building a query where you have a criterion of "Is Null" in the field that stores the foreign key ID of the person who should be missing. Assuming you have a tblPerson with a PersonID as the primary key and a tblAttendance with PersonID as a foreign key, you'll want to make a query that shows all of the records in tblPerson and all of the records in tblAttendance where the PersonID _in tblAttendance_ is null. You'll also, of course, want to filter by date, so that you're only looking at the records for the day in question.

If that doesn't get it working, write back, and we'll see what else to try. If you do write back, include the names of the tables and fields in question, so that the answers can be as accurate as possible.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.