Search results

Yeah that is a fantastic page, it's how I figured out how to get to where I am now. Got a little closer, still can't figure it out though. If I ignore the polyID field I can get it to work: SELECT Sum( ([TestTable]![Time]- Nz((SELECT TOP 1 Dupe.Time From TestTable AS Dupe WHERE dupe.PolyID...

I think I have a better understanding now. While it's probably a bit late in the game, and this may be simply a matter of preference I would have that append query set up to append all of the raw data into the table instead of just the aggregates. But I am a bit of a data junkie and I always...

I'm confused as to what the data is showing. This table is the aggregate data of each field for each week? Is it the average? Do you have the raw data? Why use a query to build this table? Why not just use the raw data and aggregate it as you see fit when you want to chart? I'm...

Seemed appropriate to have a different thread for this issue, even though I have another thread for the original issue. I have put together a nice little subquery that allows me to look at the flow of a gas over time and, by numerically differentiating time, allows me to calculate the amount...

Yeah I think you are right. I stumbled across this link while looking for an answer: http://allenbrowne.com/subquery-01.html the section "Get the value in another record" seems to have just what I need. Their example is: SELECT MeterReading.ID, MeterReading.ReadDate...

K, should have made it clear what dT means, it will be the difference in time from one record to the next. So, when the time values are: 0.5 1.2 1.7 2.1 2.5 The dT values should be 0.5 0.7 0.5 0.4 0.4 Time*Value is, on it's own meaningless because the Time is cumulative and the Value...

I need to do a numerical integration of some data, which is a breeze in Excel, but I can't figure out how to do it in Access. Here's the basic table ID Time Value 1 1 2 2 1.4 3 3 1.7 6 4 2.1 4 What I want to do is to calculate a "dT" value that I can then...

Found the link on doing the reverse cross-tab. http://spreadsheetpage.com/index.php/tip/creating_a_database_table_from_a_summary_table/ If you are working with Excel 2007 (and maybe 2010?) you have to bring up the old (2003) pivot table system, which you can do by pressing Alt-D then P, I...

Pretty sure this is exactly what I needed, thanks much!

One thing is to differentiate between search and data entry. They should be handled seperately. I'm just gonna talk on search forms because it's what I know. The way I got my search forms cleaner is that I eliminated datasheets in my forms entirely. They are bulky, have locking editing...

So, what it sounds like is that your dates were already cross-tabbed. This is something that you will want as an end result of your queries/forms/manipulations, not something you want as a base table. If you want to *reverse cross-tab* it from an excel sheet there is a way to do that. I can't...

Ah, one thing I forgot to mention. From the point of view of the users, this is an entirely read only database. It's also graphically intense. Lot's of graphs. And graphs in access seem to be a pain in the butt. I used to run graphs with bound forms using a parent/child relationship to define...

Don't use year as the foreign key there. You need an extra table I think. Try this: Customer -CustID (pk) -Name Order -OrderID (pk) Unique identifier of a specific order, could be an autonumber -Date year, full date, whatever. -CustID (relate to customer table.)...

If (desire to skip backstory) Then Goto 15 Else Read on I have been working on this database off and on for ~1 year. The first number of months were just trying to figure out how to programattically upload the data (~250-500k records in ~1k files with inconsistent formats.) But I got...

Normally when you double click on an OLE object it brings up a localized version of the program that handles the OLE object. However, if you right click and scroll down there is an option for "CS Chemdraw Object" which then goes to "Open". This gives opens the file in the full version of the...

Yeah, it's on my list of things to do in cleanup mode. Got it working now thx!

Getting the "This Select statement includes a reserved word or argument name that is mispelled or missing" error on a table, I think I know what is causing it but wanted to be sure. The following works Select PolyID, Ethflow, "" as H2RatGC, ""as C6RatGC From Trundata Where PolyID =...

Edit: Crud, don't know how I messed this up, this should be in the VBA section. If someone could move it I would appreciate it. I am working on a series of forms that will have an "export to excel" button. Originally this was a simple thing. Each form had an underlying query that defined it...

I *think* I was just fighting this problem. So you have table 1 which is: Time1 Value1 1____x 2____x 3____x 4____x 5____x 6____x and table 2 which is Time1 Value 2 2____x 4____x 6____x and what you want is Time Value1 Value2 1______x______null 2______x______x 3______x______null...

Ok, sorry to double post but I got it. It is REALLY ugly though and I am sure there is a better way to do it. Ah well. Here's the solution: So, I have the 2 source tables (in this case actually a dynamic query, easier that way) GCData and RunData. Both contain Time values, but neither...