Recent content by tsbergeron

I am new to Access. Would you please explain your "hack" solution a little better? I have the queries showing the text value but when I create a form or report, it shows the id number.

I have a query with a DateSerial Calculation field that I would like to filter the query by. The DateSerial calculates the same day of every year (5/31/"YYYY"). When I try to add a criteria sort to this field, I get a data mismatch error. Here is the code: ThirdMay...