i'm running a query on an access database with a few tables in it that i'm attaching to this.
i'm having trouble getting all of my students to show, for a previous week in the past (historical). I've attached a sample of the database along with a query (within the database queries) to demonstrate my problem. In this case "Missing Thisone" and "Missing Thisonetoo" do not show up as "NO TIME" and they should as they have no time entered for the period specified. I don't know why though....the database should open with no problem if it asks for a password use: "test"
see question "Showing time that isn't there" (response IDs: 23776811 - 22670921) for other information on this.