M
MDW
OK, this one is weird.
I'm on Access 97, and I've got a query that I'll
call "Unmatched". This query is, itself, formed of two
smaller queries.
When I open the "Unmatched" query, either in datasheet
view, or by previewing the report it's bound to, an
additional, blank record is added to the beginning of the
recordset. From what I can tell, the rest of the query
displays fine. I can delete the blank record, save the
query, and when I re-run it, the blank row is back.
However, it doesn't add additional blank rows each time I
run the query.
The two underlying queries seem to be running fine, and
the tables themselves don't seem to be affected. Any idea
what I could have done to cause this to happen?
I'm on Access 97, and I've got a query that I'll
call "Unmatched". This query is, itself, formed of two
smaller queries.
When I open the "Unmatched" query, either in datasheet
view, or by previewing the report it's bound to, an
additional, blank record is added to the beginning of the
recordset. From what I can tell, the rest of the query
displays fine. I can delete the blank record, save the
query, and when I re-run it, the blank row is back.
However, it doesn't add additional blank rows each time I
run the query.
The two underlying queries seem to be running fine, and
the tables themselves don't seem to be affected. Any idea
what I could have done to cause this to happen?