The weirdest thing is happening with my Access database today. It was fine when I left yesterday, but this morning my query, which returned all the records it was supposed to, now leaves out two. The really strange part is that these two records have nothing in common and everything else related to this query is working perfectly. It’s as if these two were deleted, but I checked. They’re definitely in the tables. The only similarity between the two is in the date, 12/27/2007 and 1/7/2008. There’s a seven in each, so I wondered if this was a glitch, but 12/17/2007 shows up as normal.
Has this happened to anyone else? What on earth could it be???
