Search results

I appreciate the quick response. Unfortunately that did not work; maybe the expression was too complicated for Access to handle. However I found a way around. Thank you again for your advice.

I appreciate everyone's help in my prior posts, but yet again my inexperience is showing. I am attempting to create a query wherein, if an individual selects a certain reporting period from a form, the results will yield either a 1 or 0 in a new column. Instead of pasting the entire code, here...

Thank you for the direction, query is now doing exactly what I want it to do. I will change my data names as well in order to alleviate any confusion with Access. Again I appreciate all the help.

Thank you for your quick responses. Fortunately, the PAC has only received a few contributions and made only four disbursements thus far, so changing the database around slightly is not going to be a problem. While I am aware of the Datepart function, I need to run additional reports, such as...

For a little background, I have created a database for my company's political action committee (PAC), which among other things, list the contributions received by the PAC as well as the disbursements the PAC has made, each are in seperate tables. As required by the Federal Election Commission...