expression

Can someone help me format this expression correctly? If the state is NJ and the credit card is Amazon then No tax but if the state is NJ and the credit card is anything other than Amazon then tax. =IF(AND(oknshipstate="NJ",okncreditcard="Amazon"),"No Tax", if...

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)...

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...

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...

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...

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...

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"...

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...

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...

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...

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...

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...

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...

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...

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.

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...

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...

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...

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...

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...