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?
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...
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.
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...
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.