expression

  1. G

    Find numbers in a string at a certain position

    Howdy everyone :) I was hoping to get some help with a situation I'm stuck with. I have an excel worksheet with data in one of the columns that looks like the following. I'm looking for an expression to find all data that has "Reads" less than 1000 (the highlighted values marked in bold)...
  2. S

    Rounding down to nearest 100

    I have a calculated field with the following Expression: Round([RecNo],-2) The RecNo field is a regular autonumber field. I want the new calculated field to round the autonumber down to the nearest 100. E.g. <tbody> AutoNumber Calculated Field 78 0 150 100 399 300 1542 1500...
  3. S

    Enter Date Parameter not working

    Good Morning, I've got a database where I run a Select Query every morning that requires me to enter in today's date. It worked fine last week and last month, but as of today I get the following error: "This expression is typed incorrectly, or it is too complex to be evaluated. For example...
  4. T

    ApplyFilter alternative?

    Hey Guys! I have a table that I need to search part numbers on.. for each single record it has multiple part number columns each named differently (PART01, PART01, PART03... PART10) I am trying to do a search form to look in these different columns a specific part number per search. I tried the...
  5. M

    Query Error

    I have two queries that are almost identical and I can't figure out why I get an error on one of them. the working query SELECT qry_final_CMS_incentives_by_line_item.* FROM qry_final_CMS_incentives_by_line_item WHERE (((IIf([TempVars]![varIncentiveTo]=[IncentiveTo],True,False))=True)); The...
  6. B

    Grouping a report based upon a number expression

    I have a report that is grouped by "expression". Their are 4 groupings and each group has a number from 1 to 4. the first grouping is grouped by the expression "=4". The second grouping is grouped on the expression "=2". The 3rd grouping, the expression is "=3" and the 4th grouping is "=1"...
  7. T

    help building an expression

    Hi! I need help building an expression for a field in a query I'm designing. I have columns of dates and types of reviews. Example: SiteID SiteDate Purpose 03500000 05/09/13 Initial Full Scope 03500000 08/17/15 Periodic Full Scope 03500001 05/09/13 Initial Full...
  8. J

    Error you tried to execute a query that does not include the specified expression

    Hi, Keep on getting error "you tried to execute a query that does not include the specified expression" My SQL looks as follows: UPDATE TblField LEFT JOIN TblTempStats ON TblField.DomainCatID = TblTempStats.DomainCatID SET TblTempStats.EmptyFields = Sum(IIf([fieldname] Is Null,1,0)); Any...
  9. T

    Applying criteria to a expression.

    It seems like I must be missing something very simple, I created a simple Query from a table with Inventory QTY transactions, they are grouped by IN and OUT transaction types. I used expression builder to to create a simple custom column [IN] - [OUT] The column is working just fine but when I...
  10. L

    SumIf Formula with Multiple Criteria

    I'm trying to create a Sumif formula that contains multiple 'ifs'. I was able to do this using the formula I pasted below but my "Type" field has grown to be too many different options and now my expression is too long for Access to handle so I need to consolidate this somehow while still...
  11. D

    Regular Expression help

    Hi All, I use SQL to export oracle transactions to a text file which are separated by the "~" tilde delimiter. Come to find out folks use the tilde in the journal descriptions, which, of course, means I would have faulty data upon importing those text files to another db. I have since updated...
  12. D

    Compile Error: Expected: Expression when creating Outlook and building email line by line

    Compile Error: Expected: Expression when creating Outlook and building email line by line Trying to have a standard body/header, and insert line items based on excel values (If 1 include line A, if 2, include line B, etc.) ANY feedback or advice would be greatly appreciated. aEmail.Body = "Hi...
  13. A

    Query to add 2 rows together

    This is hard to explain, but here goes: Simplified Data: ValueA ValueB 5 30 10 40 15 50 20 60 Can I write a query that would result in the following? Expression1 10+30 = 40 15+40 = 55 20+50 = 70 I need to add the present row + the value of the...
  14. M

    Solving algebra expression with letters

    Hi! How can I in an equation with two variable solve for x using letters in Excel? E.g. I have the following problem: y = -2*x+150 Find expression for x. I know the answer is x = -0.5*y + 75 but can Excel find that out for me? I'm new in here so I really hope you can help me. Best, Mads.
  15. R

    Convert If InStr Excel VBA to Access Expression?

    I have the below code in Excel VBA. I was wanting to try and put this into Access as an expression perhaps? The goal is to look at each record in the table and parse out the Access Profile Name. Anyone able to help me out? Dim R As Long, Data As Variant Data = Range("G2", Cells(Rows.Count...
  16. bs0d

    Calculated Table Field

    Is there a way to create a calculated field which auto increments by unique ID's in another field? For example, see CalcTime in the data set below. Starting with 1, it numbers each row until the PROP changes and starts over again. ID---- PROP---date-----CalcTime 1----- abc---1-Jan----- 1...
  17. J

    Calculating an expression stored in a string in VBA

    I need to evaluate a VBA expression in VBA, which sounds easy but I cannot figure it out... Test1 is how I want it to work, I want the Msgbox to display 2 like it does in the Test2-macro. I haven't got any versions of Evaluate to work, Application.Evaluate, ActiveSheet.Evaluate or...
  18. N

    Conditional formatting a complex condition - Need help creating the formula

    Hello. Please reference the following table for my comments: -- removed inline image --- Request Date (O) will always contain a date Original Promise Date (M) may be blank or it may contain a date After Original Promise Date is populated, at some point Current Promise Date (N) will be...
  19. bs0d

    Query Replace Function

    I'm building a query in MS Access. I have a time series of data (table 'A'), and comments with dates in a separate table (table 'B'). I have built a query to show data for an item, and the comments from Table B on the appropriate date where a matching item ID is found. Is it possible for me to...
  20. W

    Cell with an expression and using the Left formula

    I'm trying to multiply a cell with a constant and that has a non-numeric value. Example 15" (" = inches). I used the "Left" formula and it works. However, the data changes in size and would have to change the value of the Left formula from 2 to 4. Is there a better way of doing this? Like an...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top