Recent content by foobar182

Hi. I have a table that has 3 entries per date. I need to make a query that will sum the entries but only sum together entries with the same date. for example amount shift Date ------------------------ 200 1 9/2/01 300 2 9/2/01 300 3 9/2/01 100 1...

Hello. I have a form set up that enters data to a table. For a few certain types of data i need the form to automatically make two entries. for example: If name=Rob make a rob entry and make a billy entry. Right now it would of course just enter Rob. Im guessing a need a conditional...

Hello. I have a form that creates a graph from a filtering query. I only need one graph obviously but it creates like 12 different graphs that all look the same. I have no idea why. any ideas?

Hi. I have a form the when a button is clicked in it, a table is created. Problem is, most of the time an old table of the same name is over written. So i get 3 boxes popping up asking if im sure i want to do this. I need to automate the process so that OK is automaticall selected for the...

Hello. I have to graph two running sums in a report. I have these running sums calculated in a query. Now when i go to add the fields to a graph it only alows "CountOfData". This is not what i need. This only tells me how many data entries there are for each date. I need to graph the...

Hello. I need to know how to make a graph that includes running sum fields from a query. I can make a graph with these fields but it makes be "CountOfData" which is completely useless. I need Max of data or something tot hat effect but it wont let me change it. Tells me it's not allowed when...

Hello. Im having a problem with a table output query. It is setup to do running sums on two fields. The problem is when it outputs to the table it sets the data type as text when it should be a number. I need to be able to graph this data but when defined as text i cant make it do what i...

Hi. I am having a problem with running sum. I can set a text boxes properties in my report to have a running sum but the graph in the report only lets me read data from a table for query. How can i set up a running sum that is graphable within access? Thank you for any help

Hi. I am having a problem with running sum. I can set a text boxes properties in my report to have a running sum but the graph in the report only lets me read data from a table for query. How can i set up a running sum that is graphable within access? Thank you for any help

yah excel would be nice but it need this to work for any length of data and it needs to be automated with is a pain when kicking data out to excel. ill check the running sums though

never mind i found it and that fixed it.. thanks a lot for dealing with a novice

hi. well i checked form view properties but in my properties there is nothing saying form view. So i dont know if its continuous. im an idiot though so ill keep looking

hi. I have a list of data i want to graph. Only thing is, i need it to accumulate. for example lets say we have this data 1. 50 2. 50 3.100 4.150 when this plots i need it to plot the points with values like this 1.50 2.100 3.200 4.350 see how it would add as it goes? i have no clue

Well i created a form in access 97 for people to choose certain preferences and out pops a nice chart for them. When i created the form is was just a simple square with some fields and buttons in it. but when i run the form it creates the same thing like 12 times. So i can scroll down and...