Recent content by torok

Thanks to both of you for the responses. I didn't know you cuold use IIF in SQL expressions.... I'll look into making the function as well (though I'm not sure how to incorporate a function into a query yet). Again, thanks for your time :)

Does Access support CASE expressions in SQL yet, like SQL Server? As detailed here

I appreciate all your comments - they get me thinking in new ways about an old problem. I could see some inaccuracies coming in by assuming that people in the cohorts are evenly distributed by age, but that's to be expected. Every year that the model calculates, it calculates how many people...

Hi Pat! Your comments are *always* appreciated... but I'm not sure what you mean by that.... These tables are huge, and they're used for scenarios in labour market models. This data has to reflect the number of people in a particular cohort, somehow. If there's another way to do this, I'd love...

Hi everyone! I'm having a lot of difficulty with this one. Here's a tiny piece of the table: Year | Profession | Cohort | Supply | Additions | Subtractions 2000 Doctor 1 100 10 10 2000 Doctor 2 100 10 10 The cohorts...

Hi there, I use Excel as a frontend to Access, partially because my client *really* wanted to edit the Access database tables in a spreadsheet environment. My code imports sections of the tables and puts them in Excel worksheets. The client makes changes, and then my VBA code dumps the...

hmm.... my fault for being cryptic I suppose. You've got it right, except that I never match with part of a key. Just that I have 6 tables, and I do a whole lots of joins. I think I finally answered my own question, actually. To make this a bit easier there will have to be a lot more joins...

Hi there, I'm trying to figure out the best way to do this, and coul duse some input. I currently have a few data columns with primary keys KEYA KEYB KEYC, and a few other data columns with pk KEYA, KEYB, KEYC, KEYD, and a few OTHER columns with pk KEYA, KEYB. Right now I have three tables...

Doh! Of course, I should have thought of that ;) Many thanks! Brilliant solution, and it works wonderfully.

That's a brilliant idea, thanks! Unfortunately I was not as clear as I apparently should have been when defining the problem, so I will ahve to find a way to modify this solution. I don't get one row for every year - I get several rows, each with its own information. Currently my Select...

I'm intrigued by your suggestions, but I'm not 100% certain what you mean - Do you mean that I should write each query as SQL in VBA as opposed to creating the stored queries?

I'm writing a predictive modeling program with Access 2k wherein the data for each year is dependent on the data calculated for the year before it. So right now I have one query for each year that I'm predicting information, and the criteria limits the input data to the year before it. (i.e...

I'm developing a complicated predictive model program with Office 2000. There's so much data, it needs to be in Access (some tables have > 85000 rows), but some of the base tables require editing with Excel, because the end user wants to be able to use formulas to manipulate base data for each...

Thanks very much to everyone who replied! ALl solutions have merit, and I'm going to have to do a little research and testing to figure out the best way for this particular case. The final approach suggested is one similar to one that I'd been thinking about, only better. Since this will be a...

Thanks for the link (and the response!).... That's an interesting approach, and one I'll definitely take a closer look at. The volume of data I have to manipulate *might* make that solution impossible, not sure yet. (You wouldn't believe how much data I've got for each scneario - several dozen...