Recent content by cfp76

Its saying on the line Sheets("LifeOnly").Cells(r,1) that there is an expected = ...

First, using Excel 2010. Second, the raw data I'm looking at is similar to this: 0001 AUT123 0002 LIF654 LIF987 0003 AUT985 LIF456 The output I want is for all LIF elements to be reported in a nice table like this: 0002 LIF654 0002 LIF987 0003 LIF456 As you can see, the first one was...

OK - I'm trying to write a module (have had a little help from someone here but still kinda lost)... What I have is this 0001 LIF123 LIF234 0002 AUT654 LIF987 003 AUT548 I want: 0001 LIF123 0001 LIF 234 002 LIF987 So my macro is going to check the first cell and see if it contains LIF and...

I don't see why not but I don't know since I'd have to have the queries run and create the table automatically whenever the excel report is opened. I have completely changed my attack at this point :/ trying to do it fully in Excel but am not having much luck.

UGH - you are right.. I was thinking that the piece in Access that I was using was the only piece I couldn't use. BLAH - back to the drawing board. Thanks.

I don't need any parameters. And the select query I am currently using has no functions. I have a series of queries - the final query uses no functions but it is pulling from a query that uses functions (INSTR, MID, etc - standard functions in my opinion). The steps are a report is pulled from...

You answered my question.. I AM using functions in the query... so - hmmmmm I tried it again by making a query off the query that had functions and it still isn't working. I am trying to import data from Access INTO Excel I have tried 2 methods: Data>>From Access>>pick the database/query>>put...

First, I am using Office 2010. I have worked in a series of queries that can be used in Excel for a report. I go through the steps to connect to an external datasource and set it to deliver as a table in cell A1. When it "builds" the connection - there is no data. All I get is the headers...

When I use the SPLIT function in my query, it says that it unavailable....

I have a column that returns data like this: ABC~123456789~125.25~D~04-18-2013 I am trying to use INSTR to find the 2nd ~ in the string, which marks the FIRST digit in the dollar amount.... but how to I make it end at the end of the dollar amount (the next ~) All other values are a fixed...

HA! Was just coming back here to say I figured it out *face palm* It has been YEARS since I've had to do this.... found my instruction here: http://office.microsoft.com/en-us/access-help/combine-the-results-of-several-select-queries-by-using-a-union-query-HA010341541.aspx#_Toc264361444 Thanks...

Actually, I can't but here is the idea (and you may think I'm on the wrong path so PLEASE help me) I have 1 table that has been imported policynumber,data1,data2,data3 I need to report it as: policynumber, data1 policynumber, data2 policynumber, data3 (provided the write string is listed in...

Is there anyway to join 15 queries into 1 (all have the same data from a different source but need merged into 1 large query) rather than doing 12 unmatched queries? Let's say I have 5 records in the first query, 5 records in the 2nd, and 3 records in the third - I want to end up with 1 query...

Excellent - thank you for the start. I've never done anything with File Specs on import as to eliminating rows (I can do columns! heh). Will be a challenge but any direction is appreciated. Thanks!

Hello - I have a .csv file that I need to create a report from but I'm not 100% on how I'm going to go about doing it. This is the problem: the .csv is nothing that I have control over, the layout is standardized but it is not optimal as far as my skillset is concerned. In cells A1 through A9...