Stack Overflow
Stack Overflow

Questions tagged [expressionbuilder]

95 questions
0
votes
0 answers

Setting a default value for a field based on two number values in different fields in MS Acess

I am not sure if this can be done. I have 2 tables - One is a "Product" table and one is an "order_product" table, I have a field "Quantity" in "Order_product" and a field "Price" in the "Product" I would like these two values to be multiplied and…
Edel_28
  • 31
  • 9
0
votes
2 answers

MS Access Expression Builder: Invalid Use of Vertical Bars

I was handed an old Access db someone else built awhile ago. I added one field to an existing query, but when I went to save it threw an error on a different field I never touched. Error message: Invalid Use of Vertical Bars. Here is the…
CompileThis
  • 1
  • 1
0
votes
1 answer

Access Database - Nested If statements

I am currently trying to create a nested if statement field in an access database that fills data based on criteria it has to meet. So far this is what I have in the expression builder: IIf([JDE Aging Report].[Term]="PPL" And [JDE Aging…
Evert Lizama
  • 11
  • 4
0
votes
1 answer

How to map different columns of ONE table into ONE column of ONE table using Talend

I have one table with different columns. The columns belong to an Id, x and y. I would like to map those columns into One unique ID, X and Y using talend: I have a connection to my DB from MySQL to Talend. Im adding my table as a…
John Perez
  • 117
  • 10
0
votes
3 answers

Update Query takes only one row as value - Access 2000?

I am unable to understand why my Update Query takes only the value in the last row and puts it in all other, in the same column. Here are pictures: So, I need to calculate percent(PBrojProdPoTip), given BrojProdPoTip and VkBrojProdPoTip which is…
Vlad
  • 2,739
  • 7
  • 49
  • 100
0
votes
1 answer

Creating a calculated field table based on data in separate tables

It is straight forward to create a calculated field in a table that uses data IN the table... due to the fact that the expression builder is straight forward to use. However, it appears to me that the expression builder for the calculated field only…
TylerStudent
  • 15
  • 3
0
votes
0 answers

Generic C# LINQ Aggregrate without resorting to Dynamic ExpressionBuilder

How do I reuse LINQ aggregation queries on a set of generic C# types with a common shape or interface that is known at compile-time without resorting to black magic dynamic ExpressionBuilder stuff? For example, // Each "reportable" class has a…
Petrus Theron
  • 27,855
  • 36
  • 153
  • 287
0
votes
1 answer

MS Access, Use Expression Builder to Compare Field in One Table to DLookup in Another Table

I'm trying to make a MS Access report, where I use a text box to display a field value, then have another text box indicating if the first value is higher or lower than an entry in a separate table. The report has a record source of "Table 1", and…
user2059972
  • 145
  • 2
  • 11
0
votes
1 answer

Complex SSRS expression (Average of Average)

I have 4 datasets and I need to calculate the average of a field and their cumulative average. Here are my 4 datasets : Dataset1,Dataset2,Dataset3,Dataset4: This what I want . I want to find the average of the average values as given below :…
thestralFeather7
  • 529
  • 2
  • 10
  • 28
0
votes
1 answer

expression builder for XML

In my program I get passed some XML. If values in this XML fulfil a user defined criteria I store the xml otherwise it gets discarded. The problem I have is that I need to be able to allow the user to define the criteria (also combining multiple…
Retrocoder
  • 4,483
  • 11
  • 46
  • 72
0
votes
1 answer

Return none null entries with expression builder

I have an excel table that has a column called "Wire", the column is marked "x" if a wire is present is my list of materials. I imported this table into Microsoft Access Web App. For primary data below. I want it to display any materials that don't…
Zet
  • 3
  • 1
0
votes
2 answers

BIRT - expression builder: HTML Table + Dataset field does not evaluate

I am new to BIRT and its awesome but I am unable to make a bullet point list where each bullet point is a field from my dataset. Without using any html the datasetfield evaluates but as soon as I add an html tag it will simply show the name of the…
Decar
  • 5
  • 1
0
votes
0 answers

many iif statements, sum of those results

Access 2010: here are the conditions: multiply with 1.5 if: monday - friday (08:00 - 16:00) monday - friday (16:00 - 00:00) satuday - sunday(08:00 - 16:00) multiply by 2 if: monday - friday (00:00 - 08:00) saturday-…
Volkan
  • 494
  • 3
  • 14
  • 32
0
votes
1 answer

Microsoft Access - query checkbox based on textbox

I have a field text field containing dates. I also have a checkbox named "Delivered" If the text field contains a date, I would like the "Delivered" checkbox value to be "True" / ticked. If the text field isNull, the checkbox value must be "false"…
user2502658
  • 115
  • 3
  • 16
0
votes
1 answer

Joining two tables in Expression Builder

I am a new user to ms access and just now started using MS access 2003. I want to apply equality join in expression builder in a form. I want to populate Employee.EmployeeLastName from Employee table when Employee.EmpNo =…
Explorer
  • 1,491
  • 4
  • 26
  • 67
1 2 3 4
5
6 7