Search results

Just a quick one about producing cumulative totals in graphs. I've been looking at some threads and they suggest using runningsum (or something similar). The question is, do I do this in the query that I then use to produce the chart or can it be done directly in the chart?

Hi this is similar to the multitude of posts of posts about getting totals form a subform onto the main form, in that, that is exactly what I am trying to do. Initially I had a subform with two fields, Week and Cost. In the footer of the subform I had a textbox called [TotalCost] with the...

Hi again, Following on from this. Can I use this expression directly in a CrossTab query or do I have to generate these values in an initial query and then use this query to create the CrossTab query? If it is possible how do I do this?

Okay, sorry about the maths I was trying to remember the values off the top of my head without actually calculating them, hence the error. Interesting that you get the same answer for both, I really don't but I'll look at it again sometime

Okay, So I have been looking at this more and the Crosstab query does display the data in a nice a doable format. So I now have a table with the following fields Project ID Week Number Amount This does seem the best format, sorry for being a bit slow, I'm pretty new to Access (as you may...

Okay but I also need to be able to sum the values accross projects and therefore if I had seperate records for each week I would either need a seperate field for each project or a seperate table for each project, neither of which strike me as being very workable. I also need to be able to view...

Hi, Yeah I am just finding out that fields are much harder to work with. The problem is that it's just a projected forcast, so there will be no more details to break down on a weekly basis, just the one value for each project for each week, and the users need to be able to view all the weeks...

It's the presentation that I'm talking about. I am happy for the data itself to have as many decimal places as it feels like but when I display the data all the decimal places are still visible and I really don't know why. The values are calculated withing the query and the answers to the...

I have a query set up. For many of the fields I have set the decimal place property to 2, but when I vew the query it is still showing all of the digital places, i.e. 12.6783467863 rather than 12.68. Does any one know why this is and how I can sort it out? I'm using 2003

I haven't really considered other types for this yet, as I think for my data this is the nicest way to display it. I'll put up an screen print of it in the morning to see if you agree or may try and put together a sample db as I don't think I'm be very popular if I posted company finances on...

Hi, Yeah I know that would work, hence why I am using the first equation in my post. But the question is, why doesn't the second option work. One specific example is I have: Total Cost = 100400 Total Hours = 591 Week n = 1259. When I do the equation all at once without an intermediate...

I have an anomally happening in a query. From the fields: Total Hours Total Cost Week 1 Week 2 Week 3 .. Week n I am doing a simple calculation such that (this converts a cost into hours) - Before you think it is this is not the same as my other thread Expr: ([Week n]/[Total Cost])*[Total...

Thanks for getting back to me, this is just going to be a quick acnologement as I have to dash to get the train (will look more seriously in the morning). Firth thing that comes to mind is this. I need to display all 51 weeks on the form, making the form very cluttered. I was solving this my...

Hi, I am trying to create a form to display some of our costing data. I have a table that includes the following fields: Project ID Total Cost Total Hours 1 2 3 . . . 51 (where the last field represent weeks) Each of the week fields contian a percetage of the total cost as it's expected...

The data type defined by Access is text. I think it is because when importing data Access looks at the first 10 rows to determin the data type. In my case, none of the values that have letter in them occur in the first 10 rows and hence Access is seeing them as numeric even though I have...

I'm trying to import data from Excel into and existing Access table, one column has a series of values, most of these are numbers such as 831, 2123 etc, however some are a mixture of numbers and letter such as 61C. I have formatted all the cells in this column to be text and yest I am still...

Doh! Okay ignore this post, the error was not with the code but with the spreadsheet I was trying to import, the download of data to it had failed misserably and hence was in a very unexpected format. Oops, should have checked that sooner

Hi, I'm trying to automatically import an excel spreadsheet into Access using the following code. DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, "tblTabs", "C:\Rpt_pjwk_post.xls", True Problem is I keep getting the error "Runtime error 3274, external table is not in the...

Okay this is where I really show my ignorance, what do you mean by? I am still a bit stuck on how to automate the download dialog box. I have it working using Sendkeys and wait statements inbetween, but this isn't ideal. I had a good old troll around the internet and found a fair few...

Okay, I have now managedt o write the code that enters the values into the web page, all of this is now done without having to rely on sendkeys. I also found it was quicker to do it directly through IE so am no longer using a form in Access but connecting directly. Option Compare Database...