I've been avoiding this project but it has come up again. I have a file given to me each month. It contains a member number and status. The status could be any of the reason codes the user comes up with. So far there are ten. I imported the file into an access table. The users need a report summarizing the status changes if any. If there are any changes; the reason code will have a X under the reason code which pertains to them. I ran the unmatched query; but that gives me if the person was added or deleted. How do I search the reason code fields to check if there have been changes. If I ask for the nulls or is not null for each field; How would I know if it was null or not null in the beginning. I need a way to check to see if for example: Smith did not have a X under reason code 1 for the month of June but does in the month of July. I hope I didn't confuse anyone. Please help
Thanks

I would say its difficult to tell you anything with the information that you have provided. However,
This....I have a file given to me each month. It contains a member number and status. If there are any changes; the reason code will have a X under the reason code which pertains to them.tells me that you have one table with two fields. If that is all you have, then type a simple select....Query = Members with Reason Code changes...SELECT *
FROM table
WHERE [status] = "X";

I thought of this too; but what if the member had a "X" in the field last month and no "X" this month. Would I have to do two queries?

You may require a related table to contain the status and Status Change date, so you end up with a list of change in status.

I don't know your table structure slimjen, I think to answer any more questions you would have to post your file so people could disect the problem a little more. I can't answer the last question because your table could be setup more than one way (i.e. table for each month, table for each year, imported data from another program, etc, etc, etc...)....