Recent content by Cujo67Camaro

Thanks a million! Everything works fine with that query now.

I am trying to make a field in a query which displays a date based off of the criteria below. I tried nesting IIF statements but I couldn't get it to work so I tried a Case WHEN statement. CASE WHEN [Appfrom] Is Null & [Fundfrom] Is Null THEN "7/7/1999" WHEN [Appfrom] Is Null &...

Thanks! The reason I want to create a new table with the filtered information is because I would like to be able to create a few different reports based on the filtered table information. For example I would like the report to individually list cases that meet the search criteria or a report...

I have come across a snag in my access project I am currently undertaking and need some advise on what should be done next. . . In a nutshell, this project's primary purpose is to perform a search on a table of information based on many fields and generate a report based on the records which...