Hi all, I'm currently working on a db to track reservists brought up to active duty in excess of 31 days. These members are required to submit for travel reimbursement every 30 days until the end of their orders.
Info on the table structure is below. Each member will have a record in tblMarines, while only those that submitted for travel reimbursement will have a record in tblTravel. Its a One-to-Many relationship.
[DCTB] this is the start date of their orders.
[EAS] this is the end date of their orders.
[CLAIM_TYPE] the type of claim (partial, supplemental, or initial).
[START_DATE] start date of the period covered on the reimbursible period
[END_DATE] end date of the period covered on the reimbursible period
I would include a calculated field in the query that would return true: iff(datediff("d", [DCTB],[EAS])>30, "TRUE","FALSE")
Now for the big question:
Since a record in tblTravel isn't created until the member submits a travel reimbursement, How would I be able to filter out the members that have submitted a claim for the current month?
If this isn't enough information, please let me know.
Edited by: marinesct on Tue Dec 18 11:26:34 EST 2007.