Search results

  1. N

    Multiple IIf statement needs

    I need and IIf statement for this: If [major] is CS and [minimum gpa] is >3.999 and [citizen] is Yes and [Permanent Resident] is yes and [F1 Visa] is yes and [Graduate Students] is Yes then Monsanto. Can you help me?
  2. N

    Want To insert an "and" statement

    This is really a simple issue but I am having a totally "elderly moment" and cannot remember how to do it. I simply want to take the Interviewer 1 column and insert a couple of spaces and then add the Interviewer Email column so that they show up on the same line in my report. From my terrible...
  3. N

    Reserved Error (-3002) there is no message for this error

    What does this message mean?
  4. N

    Null If Statement

    I want to insert an if statement in Access report that states: If the interviewer field is not null them put in the interviewer. If it is null then don't put anything. I have 5 of the interviewer fields and don't want empty lines in the report.
  5. N

    HELP! Querry is pulling incorrect information

    I have a query that is pulling information from a database/table of employers and from a database/table of students and a couple of subforms. Query has worked beautifully for 2 years but suddenly the query will pull all information but show only one company name for all data. what has...
  6. N

    Don't want records with blank field to be included. What is criteria command?

    I have a simple access query where one of the fields I am pulling has blanks in it. I need the criteria command for the query not to pull records that are blank in the particular field I am pulling.
Back
Top Bottom