Search results

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

That worked perfect! Thank you.

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?

I did one for each using only "Y" as you suggested. Thanks again. msrp_price_new: IIf([map_enabled]="Y",[msrp_price])

It works, thanks for the link.

Self taught, sorry. But, yes there is a possibility that the MAP_Enable could be blank.

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 agree with your suggestion regarding using weird characters. Field names are being changed in my database. The file I received is a big dump of information that will be altered into something more meaningful for future use. Thank you again!

Although the field was black it had to be a zero string like you thought. Thank you. IIf(Nz([Value 2], "")="","",[,sw_] & [Label 2] & [=1] & [Value 2])

It worked! Thank you so much!

That actually worked. Thank you so much for being patient with me.

It returned sw_SLEEVE1 when it should have returned no value or been blank [Value 2) for those with no data

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_] &...

trying this again. I somewhat figure it out and it worked on my first set of fields, but it did not work on the second set. I figured I'd just break down and then combined all. Although my [Value 2] is blank the expression return all but the [Value 2] field? it should not of returned any...

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]

Perfect! Thank you :)

I'm attemting to write a simple qry IIf(Len([upc #])=13,Left([upc #],12)) it works fine by it's self but I want to add and "or" to it. basically my field consist of 13 and 12 characters so if there is 12 I want to return 11 as well as if there is 13 I want to return 12.