Search results for query: *

I'm using a tab form to deal with an application. The front page consists of a number of embedded charts which give a quick performance overview of the collected data. However these charts only update on loading and I would like to update after a data input session without closing the...

I have query which uses SQL (from this forum) to produce a running sum data set which is used for a graph. However its really slow, even after repairing and compacting. If I set up a report to display the same data set using the reports "running sum" property the results are almost...

Ive got a form which collects 4 variables from the user to feed to a query which then provides the data for a graph. Ideally I would like to include the graph on the form along with the data. Unfortunately when I do this the graph opens with no data when the form is opened and I cannot find a...

I've just noticed that when a chart is drawn summarising the data by week I get 56 weeks in the year. I've double checked by using the format ww method in a query and a years worth of data will include occasional double weeks although the data associated is different. Whats going on!

Hi I've a simple query which provides data to a graph which I would like to embellish. The underlying table supplies the date and a simple count. The query should work on this data producing a running sum. In essence all I want to do is subtract a number from the previous record from a number...

I need to graph data from a query. However I cannot get the query to do what I want. I need to add the result of a simple sum in one record to another field in the next record. While this is possible inside a table I cannot find how to do it in a query. It is also possible to do it in a report...