Search results

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

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

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

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

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

Not sure if this 100% the right board to post this question BUT... I have 1 table that has multiple entries for the ID. Here is a general example: ID Event 001 Application Started 001 Application Printed 002 Application Started 002 Application Printed 002 Application Submitted 003...

I have a report that is linked to a My SQL query written in Microsoft SQL Service Management Studio. I need to link my CRW report to that query but I'm unsure how. I'm using Crystal 10.0. I have linked 3 ODBCs to the report that my query uses but I don't know where to get the query in... HELP...

I currently have a multi-tab spreadsheet. 1 Sheet contains all data for the other tabs, which are graphs showing dollars by department. On each graph I have charted out the data: dollars and goal plus a trendline for the dollars. So, each graph has three element plotted. The x-axis is the week...

I have been working on a database for quite some time but it had its own mdw file. I took a leave from work and upon my return, and opening of my file, I am getting the following: You do not have the necessary permissions to use the E:CFP_Projects/AccessDBA/kpi_reporting.mdb object. Have your...

Does anyone have a site dedicated to helping people create the charts in Access? I can do one - but it is harder than heck to format and I am wondering if there aren't some nice tips and tricks to make formatting easier..... Thanks...

Is there any easy way of making the chart fit the page without having to stretch it? I do not want a pivot chart either - must reside in access to get on reporting screen. thanks in advance cfp

I am needing to know the SELECT command that would return all reports listed in my database.... for a table, I want a drop down box that will allow me to select the reports that I have available. thanks cfp

I have my database built - ready to begin the reports. What I want to do is have a report screen (will not be needing criteria) that has a drop down list box that will show all reports - from that list the person can pick a report and then either print or preview it. I also want an option that...

I am trying to run a query from a linked ODBC table. It is a very large table (all transactions for a specified month). Importing the table is not an option because it is so large. I get the table linked and can view it fine as a table. When I go to create a query, I set it up and try to run it...

Is there anyway to have a report have 2 record sources? I have a report that has 2 subreports within the detail and I am needing to add fields for totals in each subreport but because the main report can only have 1 record source, I get a request for a parameter. How can I do this without...

I am trying to create a query that is using 3 different tables. Table 1 - account information Table 2 - insurance detail tying to #1 via carrier code Table 3 - aging buckets for accounts, tying back by carrier code. This table is initially full of empty fields that are populated during the...