UPDATED!: Select specific records in query
UPDATE TO MY QUESTION: In my query, I need to be able to show ONLY those records that have an entry, AT PRESENT!, in that field and no others. I have tried the "between and to" and the -1 or 0 for the criteria. These both return ALL the info that has ever been in that field. All I need is the info that is there at the moment.
UPDATE TO MY QUESTION: In my query, I need to be able to show ONLY those records that have an entry, AT PRESENT!, in that field and no others. I have tried the "between and to" and the -1 or 0 for the criteria. These both return ALL the info that has ever been in that field. All I need is the info that is there at the moment.
Last edited: