Search results

Perfect. Thank you.

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

That is exactly what I needed. Works perfectly. Thank you!

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

Sorry I know. I was asked to combined several files, which was easily done via a power query, but when I reviewed the detail I thought the same! FYI, column T is not needed in my end result. Its just the file name. I only need the UPC to be carried over. Line 3 is not needed either. I'm...

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.

the data is coming from an outside source, so I am unable to restructure. All the reason for doing in order to get detail uploaded into our database.

You are correct Isladogs. Can you explain the union query. This is going to be an ongoing (daily) process and I was just hoping to link data and allow it convert with min. steps. I've unioned several spreadsheets into on in the past, but have never done what you are saying.

I'm self taught Arnegp. Mainly simple stuff in access. So, I'm not sure what you are having me do. Language is new to me. Can you give me more detail?

can you provide sample of the union query?

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

ok, if adding [] in the sql its self then it works. SELECT SW_LABEL_VALUE_UNION_QRY.A AS attribute_code, SW_LABEL_VALUE_UNION_QRY.B AS [option:value] FROM SW_LABEL_VALUE_UNION_QRY; Thank all for helping!

quotation marks are present in the field name when using returns "Silly:Name"

the fleld B needs to reflect option:value SELECT SW_LABEL_VALUE_UNION_QRY.A AS attribute_code, SW_LABEL_VALUE_UNION_QRY.B AS optionvalue FROM SW_LABEL_VALUE_UNION_QRY;

does not work as i get an "not a valid name"

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

I just found a plug in "Power Query" for excel that does what I needed. Thanks anyway for your response.

I still need help with my question?

I have never dabbled in VBA until yesterday. I can't even say I understand it honestly. I'm self taught on this end using Access very little, but have been tasked with trying find a way to pull of of this together into one table. So, any help on your end would be appreciated.

I changed, but I'm still getting the files importing separately, in addition data is uploading into one Field. Thee is something with .txt files that are diff. from excel files?