Search results

Hello, I currently have a query that I have to enter the same data several time in order to generate a report – each time the data that is entered is the same but used by the report in different ways e.g. to create a graph and display the data of text. Is there a way that I can create a form...

I have tried it but for some reason if I enter “ab” in the criteria everything works perfectly. But if I enter [name] and when the enter parameter value appears I enter ab. Allow the correct fields are returned I get an error in the column that should have the running total. Am I entering...

Is there a way that I can alter which person I want the running total to work for every time the query is run by being prompted to enter a name. Thanks, Alexander

Hello, I am trying to create a graph in access that will plot time on the X axis and a cumulative total on the y asses. I (with the help of this forum) have managed to get a Dsum function to work in the query that I want to graph. I have also managed to get a function that converts time into...

tank -you:):). Thank-you about warning me about the naming things and ‘name’ when I know how do everything that I need to do I will go back and look at the conventions like that. Thank-you so much, Alexander

Thanks If I use DSum("number","table1","[name]= 'a') the formula totals everything that where the name column = ‘a’ How do I combine this with the previous formula so that I get the running sum of this? I have tried the following but it just comes up if #error in the expr1 column...

Thank-you, I have managed to get the Dsum to work My finished expression looks like this Expr1: DSum("number","table1","[id]<=" & [id] & "") Can you tell me what the last part of the expression means because at the moment it will provide me with a running total of everything even if I filter...

Thanks Is there anyway way to avoid the SQL statements because I do not understand how they work? If not how the best way to find out hoe they works Alexander

I am trying to create a query that will show the cumulative total of samples that a predefined person has processed (agential I want to graph this in a report). I have tried to use the DSum function however I only get the total of all entries in each row e.g. they all say the same The...