Search results

Hi All, I'm having problems getting calculated query to work. At the moment, my query returns 3 values. date, close, adjustment This would look like 2015-04-10 1170 1165 2015-04-13 1163 1158 2015-04-14 1167 1162 2015-04-15 1154 1149 2015-04-16 1137 1132 2015-04-17 1127 1122...

Hi, I've attached a test.accdb. Its been hacked from the original db. In the original, the history table is a query from a larger table. The Between table is the calculated upper and lower limits written out to a table. These values are usually in two arrays. I suppose to recreate what I...

Curses!... Try again. Lets say the current date is 1st Jan 2015 I have a history of share prices running from 1st Jan 2014 up to the current date(1/1/2015) that is plotted as a line graph. In Vbscript, I am calculating a number of values and placing them in an array. I do this twice. Once is...

Hi, I've attached an image that hopefully explains things. The bottom graph is a Photoshop mockup. The calculated array of data follows a similar pattern. ie Date for next 3 months and an upper and lower value that will follow a curve starting at the last history date. El-d

Hi All, I have a simple line chart plotting price against date. I would like to plot a secondary line on this chart from an array of data that I calculate. I've searched hi and low but can't seem to find a way of doing this. The closest I've found is from this:-...

Not going to get a chance to look until later but could I pass the selection as a variable from the combo box into the query via script?

Thanks. Think I need to look into design a bit more but does seem bizarre to me that its hard to query from a drop down list. El-d

Hi All, I'm probably being stupid (new to this) but is there a way to select a query field from a combobox? I have a Table (History)that contains Record_date , Comp1 , Comp2 , Comp3 etc 1/1/13 , 1234, 2345, 3456 etc 2/1/13 , 1214, 2355, 3466 etc Basically a table of values for each Company...

Each company has values assigned to it. Can be up to 80 records that have the same date but differing info. For my history requirement, the price data is replicated across the 80 records. Not ideal, which is why I was looking to clean out this part. What I've actually done is Make a temp table...

I guess I was just trying to reduce the excess data. I've been working with test files initially - had a look at the proper file and it would import 8000+ records per day (86 companies). I figured by querying the relevant info into a table then I would only ever have 250ish (working days) rows...

At least its not so simple... makes me feel better :) The initial imported data consists of 3000+ records of which my query extracts the 30 prices for company. There's a lot of redundant data in the 3000+ records and so I wanted to filter down to a table that gives the company price for a set...

Hi All, I'm new to this, so apologies if I'm asking silly questions, but I've looked and can't see a solution. Setup is:- I import a daily csv , query (filter)the relevant columns into a temp table. Headings: Date_actual, Company ,xxx,xxx,xxx,Price data is : actual date, company 1-30...