I have created a query where I need to calculate points. The SQL View is this: SELECT Entries.Place, IIf(1,(-)*0.5,0) AS Points, IIf(3 And =1,1,0) AS...

Hi hope someone can help this novice... i have a query with the following info FIELD - APPROVED (this field shows a 1 or 0 when the query is run) TABLE - T_ALL...

I am using Access 2000 and have created a client database that has a Companies table containing company information, Contacts table containing contact...

I want my query to ask the user for either: All, 500, or 500 price range. I do this through a parameter. If they say all, I want the query to show all the...

OK, I have some sample data, not real good with IF statements in Access, Need to know if it can be done with the reult I need and how the iIF statement...

Hi, I this statement I wrote. It works for nearly all 7500 records except for a sporatic 1,200! I can't figure out why. Any suggestions? PartInj: IIf( Is...

When I write the Iif statement the value returned is the ID number of the item in the list box but not the value. How do I get the actual value returned in...

I am starting a second query, and the data I am using is my first query which contains 15 fields. I have a column that is labeled years in this query. I want...

I have the following line in a query: Type: IIf(=0 And 0,"SKIP","NO SKIP") and are numeric fields but I want the Type field to return text. I have done...

Hi, I'm hoping for some help in regards to a job which has just landed on my desk. I have been given an Access database in which there are two tables. A...

I have written several iif statements, but I am not sure how to write one to fit this problem. I have two fields in my query: EntryDateMonth and Month. I...

I want to create a query to be used in a mail merge with Word. I have a table that has a fields for company name, contact's title,contact's initial and...

Hello I have built an Iif statement in a query that will not run because it says it is to complex. If I limit the amount of Iif''s the query runs fine. I...

I have the following code as criteria in a query. It will work if CmbCustomer is not null - it filters as it should. But if CmbCustomer is null I get nothing...

I have a query and I have the following in the criteria of the ListOrder column IIf(!!="Yes",45,) I want the results to exclude only 45's from the...

I would like to return different results for different conditions more than one field. here is my IIF...

I have a switchboard with an unbound combo box. If I want to display only the records for CampusCode=1, I pulldown that CampusCode on the switchboard, and the...

I'm having a problem with the following statement SOURCE: IIf(Mid$(!,1,2)=!,!) When I added it to the SQL statement SELECT TblPROP.CODE, VARIETY.NAME,...

Below is how I have the iif statment in my query. Its not working. WHSE1: IIf(="1B","WDNVL",IIf(="2C","COKATO"",IIf(="2M", "NOVI") Basically I need the...

I need some help writing an If Then Else statment. I have a query that brings up all the animals at our farm and then the owner of each animal. Depending...