Search results

Can someone review the CheckDigit Calculation portion below? Something is off. Example 02636267000 returned check digit of 6 however it is actually 2 let Source = Excel.Workbook(File.Contents("J:\PRICE\QUERIES\144F\144F.xlsx"), null, true), Sheet1_Sheet =...

I need to delete rows between dates/times using an additional field to determine date/time range. Specifically, using the 1st "General Withdrawal" as the starting point under [Type] deleting all rows equal to or less then that date/time and then if there is a second "General Withdrawal" it...

I am trying to include an "&" statement to look at 2 columns within my SUMIF statement, but it's not working. Works fine if I'm only including 1 column. Any advise? =SUMIF(Sheet1!A2:A1000,"*001*",Sheet1!D2:1000) I want to include an IF Sheet1!C2:A1000,*01*.

I created a macro to turn off warnings (see below) and it works for me, however when someone else accesses the same data base they still receive the warnings. Please help. Private Sub cmdRunMakeTable_Click() DoCmd.Hourglass True Turns off the Access warning messages DoCmd.SetWarnings False...

I'm not sure what I'm missing here? I have a macro that should run 3 queries upon opening the database and all warning have gone away accept the Violation error. How can I get this warning to stop as well? Option Compare Database '------------------------------------------------------------...

I have a sub total on a form that I'd like capture in my master table. Is there a simple way to do this? It's the Total Received field which is a running calculation based on the sub form Invoice Reconciliation if that helps. There could be multiple transactions related to one invoice.

Attached is a payment file that I need help with please. Data is retrieved via a to/from date. In this case its from 09/03/2021 to 09/15/2021. I do this on a bi-weekly bases. What I need to do is eliminate the General Withdrawal record if one exists at the beginning of my date range along...

How do I combined the 2 expressions below? Ultimately, I want the 2nd part to override the 1st if applicable. GROSS AMT1: IIf([Transaction ID],[Gross],"") BUT or however IIf([Payflow Transaction ID (PNREF)],"",[Gross])

I'm attempting to initiate a combine power query from a folder with several .DIF files. Each file should have the same layout with 3 columns of data. That being said when attempting to combined all the data pulls into one column. I'm new to this, so I'm not sure what it is i'm doing wrong...

I have a table (see below) that has redundant [UPC], however the [Available Qty] is different. What I need is a query that can list [UPC] without duplicates, which I was able to do using DISTINCT. But, I also need my query to return a grand total FILED for [Available Qty]. Any help with the...

I have an express below that works well when the data meets the specified criteria. However, I need all data to be returned not just those adjusted based on the expression below. What am I missing? Expr2: IIf(Len([Expr1])=13,Left([Expr1],12),IIf(Len([Expr1])=12,Left([Expr1],11)))

I received an excel file where part of the record set (UPC#) is on the second line. I need to some how build an select statement incorporating it into the 1st line of each record if that makes any sense! I've attached the file I am referring to for referencing/viewing.

How do I convert columns into rows in a query. I have several [LEVELS] and hundreds of [SKU] with various prices. See sample below. Is there a simple SQL Query for doing this? My orig. data looks like this: SKU Level-1 Price Level-2 Price Level-3 Price Need it to look like this: SKU...

FIELD NAME is "B" Need to change it to "option:value", however the colon is causing a invalid syntex error? option:value:B

At first I wanted to import several .txt files into access and then I was going to perform a Union Query to combined. All worked great accept for the fields are importing into one. With that being said, I've changed my mind! I'd like to import several .txt files into access and have them...

I have over 200 excel files with like data that I need to combined. In the past with a few files I've added them as a linked file or imported the files and then created a Union Qry to combined, but 200 is a lot to link. Is there an easier way to run a union Qry without actually linking or...

I don't see an option for exporting a query to a cvs file?

3 fields involved in this question! I need to write query/statement where IF MAP_Enable = "Y" then return pricing for both Map_Price and MSRP_Price. If "N" then both MAP_Price and MSRP_Price should be blank. MAP_ENABLE MAP_PRICE MSRP_PRICE Y 1.99 1.99...

I am not an expert, so please be nice! I'm trying to write an express for if [Value 2] has no records then return "" otherwise return data from field [,sw_] & [Label 2] & [=1] & [Value 2]. I can't seem to get it to work as for those that are Null are still returning data from fields [,sw_] &...

i need to write an expression that combines several groups of fields, however if any of the "last name" fields are empty I do not want to include that group? Thoughts? =[merchant no 1] & " " & [first name1]& " " & [last name1] & " " & [merchant no 2]& " " & [first name2] & " " [last name2]