Search results

  1. C

    CASE WHEN statement problem

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

    CASE WHEN statement problem

    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 &...
  3. C

    Make table query from filtered table

    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...
  4. C

    Make table query from filtered table

    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...
Back
Top Bottom