I'm trying to set a field in the heading of a report with a expression that gives me a percentage of personnel who have been trained against personnel who training is expired or is null. I'm gettin errors or it will show as-1. I'm new at this and having a hard time with working the expressions. Any help will be appriciated.
thank you
Del Re
Hi, I want to insert an Expression in a text box of a report using VB.
This is what I wrote in the code builder section of report header.
Me.totalBox.Value = strTotalExp
Me is the header section of the report.
totalBox is the textbox.
strTotalExp is the expression that I want to enter, it is a string.
How should I do this?
Thanks.
I have a database of students that have taken tests. That database includes how many attempts it took them to pass. I have successfully generated reports that sort the exams by type, date, student, etc. I would like to also somehow insert a formula to show the pass rate of those exams on the top of the report. I know I can get into design view and build an expression, but how would I build an expression that would create a pass rate percentage based on whether or not a student passed an exam on the first attempt.
I have a DB with a column titled "Attempt" and the options "First, Second, Third, Fourth". I would like the expression to generate a percentage of students that have "First" in their box (as opposed to anything else) out of the total number of student records.
We need to track student pass rates in my school for a re-certification process.
I have an Access application that print a report with 7 sub-reports in it. When I preview the report, it looks fine. When I print it directly to the printer, it looks fine. The problem is when I print from the preview, Access error with a "...too complex..." error and crashes the application.
View 8 Replies View RelatedIs there a way to have an expression in the control source of a text box in a report, that re-starts or is exclusive for every group within the report?
View 5 Replies View RelatedGood 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
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
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
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?
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
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
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.
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?
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
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
;) 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?
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
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 RelatedHow 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
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
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
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
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 RelatedHello,
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.:)
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.
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]