Use Of OR In Expression
Sep 23, 2005
Hi
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.
Can anyone help?
Thanks
View Replies
ADVERTISEMENT
Jun 8, 2005
Good day all
Heres what im trying to do:
in one textfield i have =Count(*)
this returns all the records in my db.
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
please help
lee
View 1 Replies
View Related
Mar 15, 2006
Hi:
I'm using this expression...
=DateDiff("ww",#8/26/2005#,[cDate])
I want to add to it the ability to exclude five one week periods which are school vacations.
How can I do that?
Thanks,
xeb
View 1 Replies
View Related
Oct 22, 2006
PART NUMBER: IIf([MANUFACTOR SENT]=2,[GE PART #])OR IIf([MANUFACTOR SENT]=3,[PHILLIPS PART #])OR IIf([MANUFACTOR SENT]=1,[SYLVANIA PART #])
CAN ANYONE HELP ME FIX THIS EXPRESSION
View 1 Replies
View Related
Jun 11, 2007
I have got the following code as an expression for a report:
=Int(([Amount])/50000)*50000 & " - " & Int((([Amount])/50000)+1)*50000
How do I get it to pick figures greater than 50,000 and then figures greater than 100,000 plus?
View 3 Replies
View Related
Jun 25, 2007
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
Please any assistance would be appreciated
View 6 Replies
View Related
Feb 11, 2008
Hi All,
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?
many thanks,
Nigel
View 1 Replies
View Related
Jun 14, 2006
I need an expression for a table. I'm making a game database and for the ID input I need an expression.
For example if have a XBOX game I want the ID to be X1 or X2 etc, same goes for pc games, GameCube games: PC1 or PC2, NGC1 or NGC92 etc.
I thougt it would be "X???" Or "PC???", but that doesn't work.
Does someone knows?
Please help.
View 4 Replies
View Related
Jan 9, 2007
Okay
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?
View 6 Replies
View Related
Nov 10, 2005
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.
Best Regards,
Irish
View 11 Replies
View Related
Mar 1, 2006
Ok, I have a query that has a range of number for 1 - 126, I need and an expression that will flag sub-ranges in the list of numbers.
Example I want to group or flag results 0-25 as one group, 26-50 as another, 50 - 75 and 76 -100.
Any ideas? I statred with an IF than expression, but I can't figure how to indicate each range.
thanks
-pete
View 1 Replies
View Related
Mar 3, 2006
;) 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))
Any suggestions?
View 2 Replies
View Related
Jun 1, 2006
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:
Sector: IIf([SpacePos]=3,Left([PostalCode],[SpacePos]) & Mid([PostalCode],[SpacePos]+1,1)),IIf([SpacePos]=4,Left([PostalCode],[SpacePos])+"" & Mid([PostalCode],[SpacePos]+1,1)),IIf([SpacePos]=5,Left([PostalCode],[SpacePos]-1) & Mid([PostalCode],[SpacePos]+1,1))
I have also tried Or inbetween them but no luck either, I get the "contains invalid syntax" errors etc.
Any advise appricated
View 2 Replies
View Related
Jun 23, 2006
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?
View 2 Replies
View Related
Jul 20, 2006
How do I fix this to specify each table
Description: [level] & " " & [room] & " " & IIf(IsNull([direction]),[location],[direction] & " " & [location] & " " & [fixture] & " " & [note])
Description: [level] [level table] & " " & [room] [room table] DOESNT WORK
HELP
View 1 Replies
View Related
Oct 22, 2006
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 #])
HELP
View 4 Replies
View Related
Oct 22, 2006
IIf([MANUFACTOR SENT]=2,[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
View 1 Replies
View Related
Feb 3, 2007
I was hoping that someone could at least tell me if this is possible.
I have a table that (among other fields) has an integer field (call it X) and a date field call it Y).
I was hoping that I could create a query that captured these two fields (no problem), but also included a third, build expression field.
This latter field is supposed to be a sum of the previous X-values up until the current record date Y-value.
Ex:
If I have the following info
X Y
1 jan-3-07
3 jan-5-07
23 jan-5-07
12 jan-19-07
Then the query would be built so that the results would look like one of the following
X Y Z OR Y Z
1 jan-3-07 1 jan-3-07 1
3 jan-5-07 4 jan-5-07 27
23 jan-5-07 27
12 jan-19-07 39 jan-19-07 39
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,
-arm
View 4 Replies
View Related
Mar 14, 2007
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.
View 5 Replies
View Related
Dec 6, 2007
Hello,
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.
Thanks in advance
Simon Tickner.:)
View 4 Replies
View Related
Dec 10, 2007
I have the following expression:
expr4: IIf(InStr([expr3],")")>0,[expr3],[tick])
The above expression is returning this result:
TM)
How can I write an expression that would remove the ")"? I can't use the left function because the field varies in size (I've tried).
I have tried :
expr4: IIf(InStr([expr3],")")>0,[expr3]-1,[tick])
But this doesn't work
Thanks for your help.
View 5 Replies
View Related
Mar 24, 2008
Hi,
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.
Expr1: ([SE]*[Process Volume]+[Variation Time])/[Process Volume]
View 6 Replies
View Related
May 6, 2005
Hi,
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?
=IIf([SeriesTitle]=[Mediscope],Sum([Euro]/1.4),"[Euro]/1.2")
So basically if Mediscope is filled into the Series Title field then divide Euro field by 1.4, else divide by 1.2.
Can someone tell me what I did wrong?
Thanks!! :confused:
View 5 Replies
View Related
Feb 3, 2006
I'm confused with this expression, It seems to be typed correctly but it is not giving me back consistant results.
LTL_wb = 209.237
=IIf([txtRatingWgt]>=0 And [txtratingwgt]<=[LTL_wb],True,False)
if I put a 1000 in for txtRatingWgt it gives me True, if I put 999 I get false. If I put 50 I get false but 20 is TRUE.
Maybe this is the wrong way to go about it.
Help:confused:
View 2 Replies
View Related
Oct 22, 2006
PART NUMBER: IIf([MANUFACTOR SENT]=2,[GE PART #])OR IIf([MANUFACTOR SENT]=3,[PHILLIPS PART #])OR IIf([MANUFACTOR SENT]=1,[SYLVANIA PART #])
CAN ANYONE HELP ME FIX THIS EXPRESSION
View 2 Replies
View Related
Sep 13, 2006
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?
View 1 Replies
View Related
