Search results

Your data appears to group age groups into 5 year lumps, and you are making the assumption that each year, exactly 20% of each lump 'graduates' to the next cohort. Over many years, isn't your assumption going to smooth out the size of each cohort? And where are you going to get reasonable...

You have some normalization issues. As soon as you find yourself making fields like ThingA, ThingB, etc, you should be adding at least one more table. I would make something like the following: [tblContacts] much like you have. Ensure there is a unique ID Field, preferably an autonumber but...

If you zip the file, it is quite small (<40K). Anyways, I have attached a MODIFIED version of your database. I stripped out the modules and forms to shrink it a bit, so don't use my version as your new starting point! What you should look at is the 'relationships window' and at qryDEMO. The...

Step 0: make a copy of your database, in case you run into problems. Step 0.5: You may want to add a yes/no field to your tables to flag which records are 'reimbursible time' because there may not be any other way to tell the types of records apart after you combine tables (assuming the...

You could take this one step further. The Next of Kin (NoK) COULD be a patient as well. Rather than repeating data in two tables, the many-to-many linking table could be used to 'self-reference' the patient table (which I would then consider remaining to 'People') to identify the NoK. So, no...

If a patient can have many consultants, and a consultant can have many patients, then you have a many-to-many relationship. Seatch this forum for many great examples of how to do this.

If you have data in four fields in the same record that can be sensibly averaged together, then you may have a 'normalization' design problem with your table(s). Access has well designed aggregate functions that can operate on ONE value from SEVERAL records. However, IT IS NOT A SPREADSHEET...

You have otherwise identical tables that differ only because some describe a particular strategy/initiative rather than another? Have you considered condensing these tables down to one table and adding a 'StrategyType' field? You may also wind up with a one-to-many lookup table to describe the...

1)Put some code in the 'OnFormat' event of your report detail section that examines the field(s) where you are looking for the zero value, and if a zero is found, set the visible property of EACH control to 'False'. To avoid leaving an unsightly space, you have to set the height of each control...

kousotsu: I assume your application is for right-of-way tree management issues. I have an access db that does that same thing, and it is structured more or less as Pat has suggested. Right now, you have 8 defined complaint types, and you could probably design complex queries for summing up...

I assumed that you would be creating a calculated field in a query, which is less complicated than code.

You may have a problem with your data types. If GramWT is an integer field (i.e. long), then you are dividing an integer by another integer (254). In Access, the result will be assumed to be an integer, with whatever rounding is required done to the result. One way to avoid this is to change...

However, if you simply want the last number to become an 8, do this: int(Your Number * 10) / 10 + 0.08

So, I assume that if your number ends in 0,1, or 2 then round 'down' to the previous 0.8. Try the following: int(YourNumber*10-0.3) / 10 + 0.08

It's not our fault. We're not the United States of America. There.... 11 words.

I hate to spoil the joke, but there are eleven (11) points on the leaf on the Canadian Flag. BTW, how come the Union Jack still contains the cross for St. Patrick, which was added when Ireland was annexed by Britian?

Why do rednecks only change their baby's diapers once per week? Beacuse it says on the box: "Holds 7-10 pounds"

slightly belated... A Redneck Valentine: Collards is green my dog's name is Blue and I'm so lucky to have a sweet thang like you. Yore hair is like cornsilk a-flapping in the breeze Softer than Blue's and without all them fleas. You move like the bass, which excite me in May. You ain't got...

There were two blonde guys working for the city works department. One would dig a hole and the other would follow behind him and fill the hole in. They worked furiously all day without rest, one guy digging a hole, the other guy filling it in again. An onlooker was amazed at their hard work...

I should also mention that the calender is totally free so long as you leave the authors's credits in place