Maybe i am totally confused but here is initially what i have and what i want to do.
I currently have a db for carrer development-- i have three fields
Last Review Date
Next Discussion Due
Status
My next discussion due is on the fly-- i did a dateadd (by one year) from the last review date to get the current result for the next disussion due--
here is what i want to do with the status and am confused with how to do it--
i want the status to have three options-- completed,overdue and upcoming--
i want these to be autogenerated but am unable to find what expression i need-- as the IIf expression only gives the option of two possible results--
so how would i go about doing the expression with having three possible outcomes?
now i want to split it up. i want to count all the records for each month. my field name is datein_now but its just a normal textfield and not a date field. example in field: 05/02/02 10:24:31 AM. also got a datein textfield:05/02/02 i had Count(*) where datein_now between 05/05/01 and 05/05/31
I need help setting up an expression. I need to set the default value = date + 2. But this also needs to take into account working days. I am just having problems with the syntax for this, as i would normally do this in VBA and do not have much experience with Expression Builder. And yes it does have to be done in Expression Builder.
I know this is horribly wrong... thats why I am asking for help. IIf ((WeekDay(DateAdd ("d", 2, Date)) = 1, (DateAdd("d", 3, Date)),(DateAdd("d", 2, Date))) OR IIf (WeekDay(DateAdd ("d", 2, Date)) = 7, (DateAdd("d", 4, Date)),(DateAdd("d", 2, Date))) OR IIf (WeekDay(DateAdd ("d", 2, Date)) < 7 AND IIf (WeekDay(DateAdd ("d", 2, Date)) > 1, (DateAdd ("d", 2, Date),(DateAdd("d", 2, Date)))
I need 3 If statements: 1 for if its Saterday 1 for if its Sunday 1 for if its neither.
In VBA I would do something like this: If WeekDay(DateAdd ("d", 2. Date)) = 1 Then Box = Date() + 3 If WeekDay(DateAdd ("d", 2. Date)) = 2 Then Box = Date() + 4 If WeekDay(DateAdd ("d", 2. Date)) > 1 And WeekDay(DateAdd ("d", 2. Date)) < 7 Then Box = Date() + 2
could i get some advise on an expression i need in a query?
i have 5 fields SumMats,SumLabs,MatsDed,LabsDed,Ttreat
i need another field that will give a value on a condition. the condition is that if LabsDed isNull, MatsDed will be divided by Ttreat otherwise LabsDed will be divided instead. can this be done? if so, how could i do it?
I am trying to execute a query that calculates a retail pricing off the whsl pricing. This is the excel calculation i use: =IF(F2<10,(SUM(F2*4)),(SUM(F2*2))). I changed the IF to IIF, and replaced "F2" with "[WHSL PRICE].
However, I am getting an error that the "category" expression is not included in the function (when I have all the fields in the query) or the function if I have just the field I am trying to calculate in the query. Can somone help me understand what I am doing wrong.
I would also like this calculation to save in the table, if possible. As I use this information to update my fields in my web database.
;) I want to create a field named ErrorCases that sums the rows meeting the following conditions: The row has a ValidityReason = 2 and for the same row ExpValidity is either null or 3. I want a count of the rows meeting these condtions.
Here is the formula I have constructed that does not work.
ErrorCases: Sum(IIf(([ValidityReason]="2" And [ExpValidity] Is Null) Or ([ValidityReason]="2" And [ExpValidity]="3"),1,0))
I having some trouble trying to use an expression in my query, I have 3 indivisual exoressions in 3 fields I which work perfectly, however I want only 1 field produced so I tried placing 1 after the other as below:
How can i write an expression in a query field that will return the following text; "A","B","C","P" and "F" Base on another field when the values of that field are <=44.44, between 44.45 and 54.44, Between 54.45 and 64.44, Between 64.45 and 74.44 and above 74.45 respectively?
LETS SAY I HAVE THREE PART NUMBERS FOR DIFFERENT MANUFACTORS. IF THE USER SELECTS GE MANUFACTOR THEN THE GE PART NUMBER SHOULD BE LISTED IN PART NUMBER. I GET ERRORS WITH THIS EXPRESSION IN MY QUERRY
Expr1: IIf([MANUFACTOR SENT]="GENERAL ELECTRIC",[PART NUMBER]=[GE PART #])
this expression works fine in my querry....but i need to add to it...if the user doesnt choose 2...if he chooses 1 then i need the sylvania part number or if he chooses 3 i need the phiilips part number....so i used this expression
IIf([MANUFACTOR SENT]=2,[GE PART #])IIf([MANUFACTOR SENT]=1,[sylvania PART #])IIf([MANUFACTOR SENT]=3,[phillips PART #])
but i get errors....how do you you string the expression...or what should i do to fix
I can't seem to be able to build the right expression to achieve this. I can easily code this through a form using VB, but I assume it is equally possible through just a query.
I would be grateful for any and all help people can provide,
I am trying to write an expression that will compare names in a field to see if they are the same. then as long as the name is the same i need a field to add another field and then subtract yet another field but if there is nothing in the subtract field then i just want the answer of the two added fields.
I need a help with an expression basically I have a date taken out field and I need to find out how long a video has been taken out for since the day taken out :confused: I need it to create a new field in the query and display how many days it has been taken out.
I have the following expression in a query field and am unsure how to change the syntax so it gives me a result even if there is no data in either of the fields- SE, Process Volume or Variation time) I think its the iif statement but I don't know how to write that into my query. Could someone please help.
I'm trying to write an expression that performs one "/" expression based on a certain exception, and if else peforms something else. I can't get it to work. I'm sure something is wrong here -- does anyone know?
I have a form which is opened by two methods - one from a command button on "frmcontacts" form and two from double-click on "ordersummary" form. At the moment there is a field which populates from the command:
=[forms]![frmcontacts]![surname] which is fine if you enter it from "frmcontacts" however I want it to also populate from "ordersummary" with the same info. I thought it would be as simple as changing the command to:
=[forms]![frmcontacts]![surname] OR [forms]![order summary]![surname] but this doesn't seem to work.
I have created an expression on a form to subtract and/or add for me. The only problem I am having is trying to get this information on the form to show up on the table. Does anyone know what I can do to make the expression on the form show up on the table?
