I am creating a database to manage the volunteers in my company have worked. I have two databases, one is their volunteer information. The other database is an "HoursDatabase" where I can input the volunteer's ID number, the date, start time, and end time of each time a volunteer has been working with us. (From here I will calculate their hours volunteered, etc.) These two databases are linked by the "VolunteerIDNumber" field. I have created forms to facilitate the data entry into these two databases. The VolunteerInformation form is working perfectly, but the HoursInformation form is having some issues. I have created a tabular view form where the data can be entered and it appears to work perfectly except it refuses to order by anything other than the volunteer ID number. I would like it to order by date, or at least the "TimeIntervalIDNumber" (the primary key for the database). I would really like to keep these in some sort of chronological order. Please assist.
Thank you in advance,
Jewlia
Thank you in advance,
Jewlia