Recent content by accessjockey

Thanks Guys for the replies, It looks like the first thing I need to do is simplify the table. I was hoping to avoid generating potentially 4 separte entries each day by the same staff member rather than one entry per staff member with 4 project fields. Are you sure there is no SQL that...

Hi All, Here's a new challenge. I have a table called 'Timesheets' Each row is a record of one particular staff members time spent on a range of projects. See below. I have created the table this way to minimise the amount of records one staff member would enter each day to one row...

Hi, Yes you're correct. I didn't export the module to my databse. Once I did that it worked. However! The running total just keeps on adding to the last result of the query. Every time I fire up the query the running total adds the results of the last query to one I have just generated. Even...

Thanks for that. The example you have given me works great however, when I recreate the query using the field names of my table it fails miserably. Is there any reason why I cannot simply add to the criteria within the DSum function I have already created? It currently produces a running sum...

Hi all, I would like to add a column to this query that calculates a running total of the 'This Invoice' field. Here is the query design : This query will return results based on information provided by the user. Here is the result if I type in 001 as the project number I would like...

Thanks for trying to help. However, the code only creates a running total of the entire main table and not the results created by the query. I managed to get the same results using the DSum function but was unable to make it work when I placed user imputed criteria within the query. ie...

Thank you for your reply. The query retrieves only the invoices that have the same project number by using this criteria- Like"*"&[Enter the Project Number]&"*" - which prompts the user for the project number when the query is run. (See the design view of the query above) All I am after is a...

Thanks Ron for your prompt reply. The code you suggest simply sums all the values within the field 'ThisInvoice' in the 'Invoices' table. I am looking to generate a cumulative total for the records retrieved by the query named 'RunningTotal' and its criteria (ie. List all invoices by the same...

Hi all, I am trying to create a running total field within a query that has a criteria as well. Here is the query in design view: This is the result when the query is run if I use the project number 001; I would like to create a separate field that calculates the running total...