thanks for any help offered. I am relearning access and trying to create a query that returns results from six columns based on one criteria. To limit my problem, I entered the criteria in the first column I want to query. The correct result is displayed but access returns a value in a few of the other columns that I didn’t ask for. I tried putting Is Not Null in the criteria for those columns but still get the same result. I thought it might be spaces that came in from the excel spreadsheet and so I trimmed the data and reloaded it. Getting the same result. My table is set up as follows:

Journal Name – Article Name – DatePub – FA – LA – 4<LA – L<4A – GA – GA2 – GrpA

It’s a db w/ faculty who co-author journal articles and each column has the possibility to be included. Most of the time it’s 2 or 3 authors. I put in the authorcode (abbrev name) for criteria in the first column. I am still getting other author codes in the following columns.

I hope I have explained this well enough. Thanks again for any help.

See description entered