Search results

Nearly there. I had to turn the query into a make table query as for some reason the chart did not like using the query directly. Not the slickest method in the world but it works. Last challenge, to plot 2 series on the chart. TRANSFORM...

I'm just relieved it is working and I can move on. :)

SELECT qry4.[DATE COMPL], qry4.Index, (Select Sum(Index) From NEWQRY_DR1 WHERE NEWQRY_DR1.[DATE COMPL] <= qry4.[DATE COMPL]) AS RunningSumIndex FROM NEWQRY_DR1 AS qry4 WHERE (((qry4.[DATE COMPL]) Is Not Null)); Finally, the above syntax has worked. Still don't fully understand why, but to be...

The second approach doesn't work either, I get an error ??? I think, but I'm not sure, the problem stems from using a date field to control the sum function. So, forget sum, it doesn't work. How do I run a query that sorts a set of dates into chronological order and then adds a sequential...

The space was missing, but makes no difference. SELECT tblalias.[ORDER DATE], tblalias.[Arrival Rate Index], (Select Sum('Arrival Rate Index') From NEWQRY_CUMULATIVE_ARRIVAL_RATE1 WHERE NEWQRY_CUMULATIVE_ARRIVAL_RATE1.[ORDER DATE] <= tblalias.[ORDER DATE]) AS RunningSum FROM...

OK, this is getting silly :( and very frustrating. If I accept for a second that I have to set up an alias table in my query ( no problem with that bit ) even though I don't know why then how come I now get a syntax error ? This is my template taken from the database example, SELECT Tbl3.ID...

The data is for a cumulative flow chart in a report. I am going to try creating the query on the fly using vba and see if I can't add the data that way.

Granted, the example works, but I'm still confused. How come the query is refering to a table called 'tbl3' when I can't see this in the table view, and how come if I change the SQL to 'table3', ( the table in the table view ) does the SQL fall over e.g. SELECT Table3.ID, Table3.Date1...

Like many people, I am struggling with getting a cumulative total to work in a query. I think I need to use DSUM but everything I have tried fails ( and I've been trying for hours ). I have a list of dates ( 203 records in all ) sorted in ascending order, for example, DATE COMPL 20/06/2006...

Cheers. I guess it's not a 5 minute job :) then. Then again if its hard to do, probably means its worth doing.

Awesome, worked first time :) thanks.

Thanks, never thought of using excel add-ins in msaccess. If that does not work I'll have to teach myself the theory before trying to explain it to anyone else.

How do I query data like this :- Year Week 2006 10 2006 25 2007 10 2007 10 2007 20 2008 20 2008 20 to turn it into this :- Year Week Arrival Rate 2006 10 1 2006 25 1 2007 10 2 2007 20 1 2008 20 2...

I am currently using an add-in to excel, ( Queueing Toolpak 4.0 : http://www.business.ualberta.ca/aingolfsson/QTP/ ) to analyse the work arriving and leaving a department. From this I can calculate the level of service plus various other queuing variables, like resource utilisation. Up to now...

:) Anyone tried applying this in MSAccess ?

Morning Everyone, I have a query in which are 5 categories and 5 values. I am displaying this query in a pie chart on a report. Q1 : Why, having designed one chart does the report repeat the chart 5 times ? I only want one chart on one page, not 5 copies of the same chart over 5 pages. It...

Bit after the fact, but helped me today :)

Me.cmdPaybackGroup.SetFocus works a treat where 'cmdPaybackGroup' is a control on the tab I want to see first. Sorted - thanks.

Can I specify which tab is in view when my form opens ? At the moment the tab I want users to see is not the one MSAccess chooses to show. Can I use something like "me.pgGeneral.PageIndex=5". This does not work by the way to specify the tab that is in view when the form opens. I don't want to...

Thanks, works a treat :)